APPS.PAY_AU_SUPER_FF SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 59

select pdb.defined_balance_id
  from pay_balance_dimensions pbd,
       pay_defined_balances   pdb
 where pbd.dimension_name = v_bal_dim
   and pdb.balance_type_id   = p_bal_id
   and pdb.balance_dimension_id = pbd.balance_dimension_id;

Line: 67

select pbt.balance_name
from   pay_balance_types pbt
where  pbt.balance_type_id = p_bal_id;