DBA Data[Home] [Help]

APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 1015: from pay_personal_payment_methods_f pppm,

1011: cursor csr_bank_data (p_asg_id number, p_eff_date date) is
1012: select pea.segment1 seg1,
1013: pea.segment3 seg3,
1014: pea.segment2 seg2
1015: from pay_personal_payment_methods_f pppm,
1016: pay_external_accounts pea,
1017: pay_org_payment_methods_f porg,
1018: pay_legislation_rules plr
1019: where pppm.assignment_id = p_asg_id

Line 1027: from pay_personal_payment_methods_f pppm2,

1023: and plr.rule_type = 'E'
1024: and pea.territory_code = 'ZA'
1025: and pppm.priority =
1026: ( select min(pppm2.priority)
1027: from pay_personal_payment_methods_f pppm2,
1028: pay_external_accounts pea2,
1029: pay_org_payment_methods_f porg2,
1030: pay_legislation_rules plr2
1031: where pppm2.assignment_id = pppm.assignment_id