DBA Data[Home] [Help]

APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 1019: pay_org_payment_methods_f porg,

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

Line 1031: pay_org_payment_methods_f porg2,

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