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

Line 180: pay_defined_balances pdb

176: IS
177: SELECT pdb.defined_balance_id
178: FROM pay_balance_dimensions pbd,
179: pay_balance_types pbt,
180: pay_defined_balances pdb
181: WHERE pbd.dimension_name = p_dimension_name
182: AND pbd.business_group_id IS NULL
183: AND pbd.legislation_code = 'DK'
184: AND pbt.balance_name = p_balance_name

Line 192: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

188: AND pdb.balance_dimension_id = pbd.balance_dimension_id
189: AND pdb.business_group_id IS NULL
190: AND pdb.legislation_code = 'DK';
191:
192: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
193: BEGIN
194: OPEN csr_defined_balance_id;
195: FETCH csr_defined_balance_id INTO l_defined_balance_id;
196: CLOSE csr_defined_balance_id;

Line 411: FROM pay_defined_balances pdb

407:
408: /* Modified for pension changes */
409: CURSOR get_def_bal_id(p_balance_name VARCHAR2) IS
410: SELECT pdb.defined_balance_id
411: FROM pay_defined_balances pdb
412: ,pay_balance_types pbt
413: ,pay_balance_dimensions pbd
414: WHERE pbt.legislation_code='DK'
415: AND pbt.balance_name = p_balance_name