DBA Data[Home] [Help]

APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 173: pay_defined_balances pdb

169: pbt.legislation_code,
170: pdb.defined_balance_id
171: from pay_balance_types pbt,
172: pay_balance_dimensions pbd,
173: pay_defined_balances pdb
174: where pbt.balance_type_id = p_balance_type_id
175: and pbd.balance_dimension_id = p_balance_dimension_id
176: and pdb.balance_type_id = pbt.balance_type_id
177: and pdb.balance_dimension_id = pbd.balance_dimension_id;

Line 529: pay_defined_balances pdb

525: p_dimension in varchar2
526: ) is
527: select pdb.defined_balance_id
528: from pay_balance_types pbt,
529: pay_defined_balances pdb
530: where pdb.balance_type_id = pbt.balance_type_id
531: and pbt.balance_name = p_balance
532: and pdb.balance_dimension_id = (select balance_dimension_id
533: from pay_balance_dimensions