DBA Data[Home] [Help]

APPS.PAY_NZ_HOLIDAYS_2003 dependencies on PAY_BALANCE_TYPES

Line 233: , pay_balance_types pbt

229: ,p_dimension_name varchar2
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

Line 349: , pay_balance_types pbt

345: ,p_dimension_name varchar2
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