APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 171: pay_balance_dimensions pbd,

167: pbd.database_item_suffix,
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

Line 522: from pay_balance_dimensions

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
523: where dimension_name = p_dimension);
524:
525:
526: l_archive_index number := 0;