eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PAY_EXTERNAL_ACCOUNTS

Line 1007: l_bank_branch_code pay_external_accounts.segment1%type;

1003: and hoi.org_information_context = 'ZA_LEGAL_ENTITY';
1004:
1005:
1006: --Bank Data:
1007: l_bank_branch_code pay_external_accounts.segment1%type;
1008: l_bank_account_number pay_external_accounts.segment3%type;
1009: l_bank_account_type pay_external_accounts.segment2%type;
1010:
1011: cursor csr_bank_data (p_asg_id number, p_eff_date date) is

Line 1008: l_bank_account_number pay_external_accounts.segment3%type;

1004:
1005:
1006: --Bank Data:
1007: l_bank_branch_code pay_external_accounts.segment1%type;
1008: l_bank_account_number pay_external_accounts.segment3%type;
1009: l_bank_account_type pay_external_accounts.segment2%type;
1010:
1011: cursor csr_bank_data (p_asg_id number, p_eff_date date) is
1012: select pea.segment1 seg1,

Line 1009: l_bank_account_type pay_external_accounts.segment2%type;

1005:
1006: --Bank Data:
1007: l_bank_branch_code pay_external_accounts.segment1%type;
1008: l_bank_account_number pay_external_accounts.segment3%type;
1009: l_bank_account_type pay_external_accounts.segment2%type;
1010:
1011: cursor csr_bank_data (p_asg_id number, p_eff_date date) is
1012: select pea.segment1 seg1,
1013: pea.segment3 seg3,

Line 1016: pay_external_accounts pea,

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

Line 1028: pay_external_accounts pea2,

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