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_DIMENSIONS

Line 2378: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE)

2374: -- 1.0 16-MAR-04 snekkala Created this function --
2375: ----------------------------------------------------------------------------
2376: FUNCTION get_def_bal_id
2377: (p_balance_name IN pay_balance_types.balance_name%TYPE
2378: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE)
2379: RETURN NUMBER
2380: IS
2381:
2382: CURSOR csr_def_bal_id

Line 2387: ,pay_balance_dimensions pbd

2383: IS
2384: SELECT pdb.defined_balance_id
2385: FROM pay_defined_balances pdb
2386: ,pay_balance_types pbt
2387: ,pay_balance_dimensions pbd
2388: WHERE pbt.balance_name = p_balance_name
2389: AND pbd.dimension_name = p_dimension_name
2390: AND pdb.balance_type_id = pbt.balance_type_id
2391: AND pbt.legislation_code = 'CN'