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

Line 1645: FROM pay_personal_payment_methods_f ppm

1641: ------------
1642: /* Cursor to check if bank details are attached with ppm */
1643: CURSOR csr_chk_bank(p_ppm_id NUMBER) IS
1644: SELECT ppm.external_account_id
1645: FROM pay_personal_payment_methods_f ppm
1646: WHERE ppm.personal_payment_method_id = p_ppm_id
1647: AND p_date_earned BETWEEN ppm.effective_start_date AND ppm.effective_end_date;
1648: -------------
1649: /* Cursor to retrieve Organization Payment Method Information */

Line 1682: pay_personal_payment_methods_f ppm,

1678: ppttl.payment_type_name pay_type,
1679: ppp.value value
1680: FROM pay_external_accounts pea,
1681: pay_org_payment_methods_f pop,
1682: pay_personal_payment_methods_f ppm,
1683: pay_assignment_actions paa,
1684: pay_payment_types ppt,
1685: pay_payment_types_tl ppttl,
1686: pay_pre_payments ppp