DBA Data[Home] [Help]

APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 172: pay_defined_balances pdb

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

Line 518: pay_defined_balances pdb

514: p_dimension in varchar2
515: ) is
516: select pdb.defined_balance_id
517: from pay_balance_types pbt,
518: pay_defined_balances pdb
519: where pdb.balance_type_id = pbt.balance_type_id
520: and pbt.balance_name = p_balance
521: and pdb.balance_dimension_id = (select balance_dimension_id
522: from pay_balance_dimensions