APPS.PAY_RUN_BALANCE_WF_PKG SQL Statements

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

Line: 14

select pbv.run_balance_status
,      pbv.balance_load_date
,      hl.meaning
from   pay_balance_validation pbv
,      hr_lookups hl
where  pbv.defined_balance_id = p_def_bal_id
and    pbv.business_group_id = p_bg_id
and    hl.lookup_type = 'RUN_BALANCE_STATUS'
and    hl.lookup_code = pbv.run_balance_status;

Line: 85

select pbd.dimension_level
,      hl.meaning
from   pay_balance_dimensions pbd
,      pay_defined_balances db
,      hr_lookups hl
where  pbd.balance_dimension_id = db.balance_dimension_id
and    db.defined_balance_id = p_defined_balance_id
and    hl.lookup_type = 'PAY_BRA_BALANCE_LEVEL'
and    hl.lookup_code = pbd.dimension_level;