DBA Data[Home] [Help]

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_BALANCE_TYPES

Line 179: pay_balance_types pbt,

175: CURSOR csr_defined_balance_id
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'

Line 412: ,pay_balance_types pbt

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
416: AND pbd.legislation_code = 'DK'