DBA Data[Home] [Help]

APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 1017: pay_org_payment_methods_f porg,

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
1020: and pea.external_account_id = pppm.external_account_id
1021: and pea.id_flex_num = plr.rule_mode

Line 1029: pay_org_payment_methods_f porg2,

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
1032: and pea2.external_account_id = pppm2.external_account_id
1033: and pea2.id_flex_num = plr2.rule_mode