DBA Data[Home] [Help]

APPS.PAY_NZ_HOLIDAYS_2003 dependencies on PAY_BALANCE_DIMENSIONS

Line 234: , pay_balance_dimensions dim

230: )is
231: select defined_balance_id
232: from pay_defined_balances pdb
233: , pay_balance_types pbt
234: , pay_balance_dimensions dim
235: where pdb.balance_type_id = pbt.balance_type_id
236: and pdb.balance_dimension_id = dim.balance_dimension_id
237: and pbt.balance_name = p_balance_name
238: and dim.dimension_name = p_dimension_name

Line 350: , pay_balance_dimensions dim

346: )is
347: select defined_balance_id
348: from pay_defined_balances pdb
349: , pay_balance_types pbt
350: , pay_balance_dimensions dim
351: where pdb.balance_type_id = pbt.balance_type_id
352: and pdb.balance_dimension_id = dim.balance_dimension_id
353: and pbt.balance_name = p_balance_name
354: and dim.dimension_name = p_dimension_name