Introduction:
This Post illustrates the steps required to get Personal Payment Method Details in Fusion HCM
Script to Personal Payment Method Details in Fusion HCM
SELECT per_pay.*
FROM per_all_people_f peo,
per_all_assignments_f asg,
per_person_names_f per_name,
per_periods_of_service ser,
pay_pay_relationships_dn pay_rel,
pay_personal_payment_methods_f per_pay,
pay_org_pay_methods_f org_pay,
pay_bank_accounts bnk_act,
per_legislative_data_groups ldg,
per_person_types_tl per_typ,
per_legal_employers ple
WHERE asg.person_id = peo.person_id
AND ser.person_id = peo.person_id
AND per_name.person_id = peo.person_id
AND peo.person_id = pay_rel.person_id
AND asg.period_of_service_id = ser.period_of_service_id
AND asg.person_type_id = per_typ.person_type_id
AND asg.legal_entity_id = ple.organization_id
AND pay_rel.payroll_relationship_id = per_pay.payroll_relationship_id
AND per_pay.org_payment_method_id = org_pay.org_payment_method_id
AND org_pay.legislative_data_group_id = ldg.legislative_data_group_id
AND per_pay.bank_account_id = bnk_act.bank_account_id(+)
AND asg.primary_flag = ‘Y’
AND asg.assignment_type IN (‘E’, ‘C’, ‘N’, ‘P’)
AND asg.assignment_status_type = ‘ACTIVE’
AND per_name.name_type = ‘GLOBAL’
AND ple.status = ‘A’
AND per_typ.LANGUAGE = USERENV (‘LANG’)
AND TRUNC (SYSDATE) BETWEEN peo.effective_start_date AND peo.effective_end_date
AND TRUNC (SYSDATE) BETWEEN asg.effective_start_date AND asg.effective_end_date
AND TRUNC (SYSDATE) BETWEEN per_name.effective_start_date
AND per_name.effective_end_date
AND TRUNC (SYSDATE) BETWEEN ple.effective_start_date AND ple.effective_end_date
AND TRUNC (SYSDATE) BETWEEN org_pay.effective_start_date
AND org_pay.effective_end_date
AND TRUNC (SYSDATE) BETWEEN per_pay.effective_start_date
AND per_pay.effective_end_date
Summary
This Post described the script for Personal Payment Method Details in Fusion HCM
Queries
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
