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.HR_EFC_INFO dependencies on PAY_PAYMENT_TYPES

Line 40: FROM pay_payment_types ppt

36: CURSOR csr_fetch_payment_types(c_payment_type_id IN number) IS
37: SELECT ppt.payment_type_name
38: , ppt.territory_code
39: , ppt.category
40: FROM pay_payment_types ppt
41: WHERE ppt.payment_type_id = c_payment_type_id;
42: --
43: -- ----------------------------------------------------------------------------
44: -- |------------------------------< get_bg >----------------------------------|

Line 745: FROM pay_payment_types ppt

741: ,c_territory_code IN VARCHAR2) IS
742: SELECT ppt.payment_type_id
743: , ppt.category
744: , ppt.currency_code
745: FROM pay_payment_types ppt
746: WHERE ppt.payment_type_name = c_payment_type
747: AND ppt.territory_code = c_territory_code;
748: --
749: CURSOR csr_check_map_exists_null(c_payment_type IN VARCHAR2) IS

Line 753: FROM pay_payment_types ppt

749: CURSOR csr_check_map_exists_null(c_payment_type IN VARCHAR2) IS
750: SELECT ppt.payment_type_id
751: , ppt.category
752: , ppt.currency_code
753: FROM pay_payment_types ppt
754: WHERE ppt.payment_type_name = c_payment_type
755: AND ppt.territory_code IS NULL;
756: --
757: --