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_CN_DEDUCTIONS dependencies on PAY_BALANCE_TYPES

Line 2388: (p_balance_name IN pay_balance_types.balance_name%TYPE

2384: -- 1.0 16-MAR-04 snekkala Created this function --
2385: --1.1 13-Mar-13 mdubasi Handled no-data found --
2386: ----------------------------------------------------------------------------
2387: FUNCTION get_def_bal_id
2388: (p_balance_name IN pay_balance_types.balance_name%TYPE
2389: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE)
2390: RETURN NUMBER
2391: IS
2392:

Line 2397: ,pay_balance_types pbt

2393: CURSOR csr_def_bal_id
2394: IS
2395: SELECT pdb.defined_balance_id
2396: FROM pay_defined_balances pdb
2397: ,pay_balance_types pbt
2398: ,pay_balance_dimensions pbd
2399: WHERE pbt.balance_name = p_balance_name
2400: AND pbd.dimension_name = p_dimension_name
2401: AND pdb.balance_type_id = pbt.balance_type_id