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 1009: l_bank_branch_code pay_external_accounts.segment1%type;

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

Line 1010: l_bank_account_number pay_external_accounts.segment3%type;

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

Line 1011: l_bank_account_type pay_external_accounts.segment2%type;

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

Line 1018: pay_external_accounts pea,

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

Line 1030: pay_external_accounts pea2,

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