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

Line 547: pay_payment_types ppt

543: -- Bug 4644507. Removed the usage of per_business_groups from the cursor.
544: cursor csr_is_valid is
545: select null
546: from pay_org_payment_methods_f opm,
547: pay_payment_types ppt
548: where opm.org_payment_method_id = p_org_payment_method_id
549: and p_effective_date
550: between opm.effective_start_date
551: and opm.effective_end_date

Line 616: , pay_payment_types pyt

612: --
613: cursor csr_chk_pay_type is
614: select pyt.category
615: from pay_org_payment_methods_f opm
616: , pay_payment_types pyt
617: where p_org_payment_method_id = opm.org_payment_method_id
618: and opm.payment_type_id = pyt.payment_type_id
619: and p_effective_date between opm.effective_start_date
620: and opm.effective_end_date;

Line 624: l_category pay_payment_types.category%type;

620: and opm.effective_end_date;
621: --
622: -- Local Variables
623: --
624: l_category pay_payment_types.category%type;
625: --
626: --
627: -- -------------------------------------------------------------------------
628: -- |---------------------< chk_payee_id_and_type >-----------------------|

Line 1066: , pay_payment_types pyt

1062: --
1063: cursor csr_chk_pay_type is
1064: select null
1065: from pay_org_payment_methods_f opm
1066: , pay_payment_types pyt
1067: where p_org_payment_method_id = opm.org_payment_method_id
1068: and opm.payment_type_id = pyt.payment_type_id
1069: and p_effective_date between opm.effective_start_date
1070: and opm.effective_end_date