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_NO_PAYSLIP_ARCHIVE dependencies on PAY_PAYMENT_TYPES

Line 2582: pay_payment_types ppt,

2578: ppttl.payment_type_name pay_type,
2579: ppp.value value
2580: FROM pay_org_payment_methods_f pop,
2581: pay_assignment_actions paa,
2582: pay_payment_types ppt,
2583: pay_payment_types_tl ppttl,
2584: pay_pre_payments ppp
2585: WHERE paa.assignment_action_id = p_prepay_assact_id
2586: AND ppt.payment_type_id = pop.payment_type_id

Line 2583: pay_payment_types_tl ppttl,

2579: ppp.value value
2580: FROM pay_org_payment_methods_f pop,
2581: pay_assignment_actions paa,
2582: pay_payment_types ppt,
2583: pay_payment_types_tl ppttl,
2584: pay_pre_payments ppp
2585: WHERE paa.assignment_action_id = p_prepay_assact_id
2586: AND ppt.payment_type_id = pop.payment_type_id
2587: AND ppt.payment_type_id = ppttl.payment_type_id

Line 2613: pay_payment_types ppt,

2609: FROM pay_external_accounts pea,
2610: pay_org_payment_methods_f pop,
2611: pay_personal_payment_methods_f ppm,
2612: pay_assignment_actions paa,
2613: pay_payment_types ppt,
2614: pay_payment_types_tl ppttl,
2615: pay_pre_payments ppp
2616: WHERE
2617: -- pea.id_flex_num=20 AND

Line 2614: pay_payment_types_tl ppttl,

2610: pay_org_payment_methods_f pop,
2611: pay_personal_payment_methods_f ppm,
2612: pay_assignment_actions paa,
2613: pay_payment_types ppt,
2614: pay_payment_types_tl ppttl,
2615: pay_pre_payments ppp
2616: WHERE
2617: -- pea.id_flex_num=20 AND
2618: pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)