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

Line 1242: FROM pay_personal_payment_methods_f ppm

1238: WHERE assignment_action_id = p_prepay_assact_id;
1239: /* Cursor to check if bank details are attached with ppm */
1240: CURSOR csr_chk_bank(p_ppm_id NUMBER) IS
1241: SELECT ppm.external_account_id
1242: FROM pay_personal_payment_methods_f ppm
1243: WHERE ppm.personal_payment_method_id = p_ppm_id
1244: AND p_date_earned BETWEEN ppm.effective_start_date
1245: AND ppm.effective_end_date;
1246: /* Cursor to retrieve Organization Payment Method Information */

Line 1279: pay_personal_payment_methods_f ppm,

1275: ppttl.payment_type_name pay_type,
1276: ppp.value value
1277: FROM pay_external_accounts pea,
1278: pay_org_payment_methods_f pop,
1279: pay_personal_payment_methods_f ppm,
1280: pay_assignment_actions paa,
1281: pay_payment_types ppt,
1282: pay_payment_types_tl ppttl,
1283: pay_pre_payments ppp