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_SA_ARCHIVE dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 1535: FROM pay_personal_payment_methods_f ppm

1531:
1532: /* Cursor to check if bank details are attached with ppm */
1533: CURSOR csr_chk_bank(p_ppm_id NUMBER) IS
1534: SELECT ppm.external_account_id
1535: FROM pay_personal_payment_methods_f ppm
1536: WHERE ppm.personal_payment_method_id = p_ppm_id
1537: AND p_date_earned BETWEEN ppm.effective_start_date
1538: AND ppm.effective_end_date;
1539:

Line 1575: pay_personal_payment_methods_f ppm,

1571: ppttl.payment_type_name pay_type,
1572: ppp.value value
1573: FROM pay_external_accounts pea,
1574: pay_org_payment_methods_f pop,
1575: pay_personal_payment_methods_f ppm,
1576: pay_assignment_actions paa,
1577: pay_payment_types ppt,
1578: pay_payment_types_tl ppttl,
1579: pay_pre_payments ppp