DBA Data[Home] [Help]

APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 1017: from pay_personal_payment_methods_f pppm,

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

Line 1029: from pay_personal_payment_methods_f pppm2,

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