DBA Data[Home] [Help]

APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PAY_LEGISLATION_RULES

Line 1020: pay_legislation_rules plr

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
1024: and plr.LEGISLATION_CODE = 'ZA'

Line 1032: pay_legislation_rules plr2

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
1036: and plr2.LEGISLATION_CODE = 'ZA'