DBA Data[Home] [Help]

APPS.PAY_NL_LSS_FUNCTIONS dependencies on PAY_BALANCE_DIMENSIONS

Line 241: pay_balance_dimensions pbd

237: ,c_dimension_name VARCHAR2) IS
238: SELECT defined_balance_id
239: FROM pay_defined_balances pdb,
240: pay_balance_types pbt,
241: pay_balance_dimensions pbd
242: WHERE pbt.balance_name = c_balance_name
243: AND pbd.legislation_code = 'NL'
244: AND pbd.DIMENSION_NAME = c_dimension_name
245: AND pdb.balance_type_id = pbt.balance_type_id

Line 623: pay_balance_dimensions pbd

619: ,c_dimension_name VARCHAR2) IS
620: SELECT defined_balance_id
621: FROM pay_defined_balances pdb,
622: pay_balance_types pbt,
623: pay_balance_dimensions pbd
624: WHERE pbt.balance_name = c_balance_name
625: AND pbd.legislation_code = 'NL'
626: AND pbd.DIMENSION_NAME = c_dimension_name
627: AND pdb.balance_type_id = pbt.balance_type_id