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_NL_PAYSLIP_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 79: ,pay_defined_balances pdb

75: CURSOR csr_defined_balance_id is
76: SELECT pdb.defined_balance_id
77: FROM pay_balance_dimensions pbd
78: ,pay_balance_types pbt
79: ,pay_defined_balances pdb
80: WHERE pbd.database_item_suffix = p_dimension_name
81: AND pbd.business_group_id is null
82: AND pbd.legislation_code='NL'
83: AND pbt.balance_name = p_balance_name

Line 91: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

87: AND pdb.balance_dimension_id= pbd.balance_dimension_id
88: AND pdb.business_group_id is null
89: AND pdb.legislation_code='NL';
90: --
91: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
92: --
93: BEGIN
94: --
95: OPEN csr_defined_balance_id ;

Line 367: pay_defined_balances pdb

363: pbt.legislation_code,
364: pdb.defined_balance_id
365: FROM pay_balance_types pbt,
366: pay_balance_dimensions pbd,
367: pay_defined_balances pdb
368: WHERE pdb.balance_type_id = pbt.balance_type_id
369: AND pdb.balance_dimension_id = pbd.balance_dimension_id
370: AND pbt.balance_type_id = p_balance_type_id
371: AND pbd.balance_dimension_id = p_balance_dimension_id;

Line 2713: ,pay_defined_balances pdb

2709: ,p_bus_group_id NUMBER) IS
2710: SELECT pdb.defined_balance_id defined_balance_id
2711: FROM pay_balance_dimensions pbd
2712: ,pay_balance_types pbt
2713: ,pay_defined_balances pdb
2714: WHERE pbd.database_item_suffix = p_dimension
2715: AND pbt.balance_name = p_balance_name
2716: AND (pbt.business_group_id = p_bus_group_id
2717: OR pbt.legislation_code = 'NL')