Fusion HCM – Query for Personal Payment Method Details

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
  • February 15, 2019 | 24 views
  • Comments