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_NZ_EFT dependencies on PAY_EXTERNAL_ACCOUNTS

Line 60: ,pay_external_accounts pea

56: IS
57: SELECT SUBSTR(pea.segment1,3,4)||SUBSTR(LPAD(pea.segment2,8,'0'),2,7)
58: FROM pay_pre_payments ppp
59: ,pay_personal_payment_methods_f ppmf
60: ,pay_external_accounts pea
61: WHERE ppp.pre_payment_id = c_pre_payment_id
62: AND ppp.personal_payment_method_id = ppmf.personal_payment_method_id
63: AND ppmf.external_account_id = pea.external_account_id
64: AND c_effective_date BETWEEN ppmf.effective_start_date AND ppmf.effective_end_date;