APPS.PAY_KR_YEA20030101_PKG SQL Statements

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

Line: 14

SELECT pdb.defined_balance_id
 FROM pay_balance_types        pbt,
      pay_defined_balances     pdb,
      pay_balance_dimensions   pbd
 WHERE pbt.balance_name    like 'Overseas Earnings'
   and pbt.legislation_code     = 'KR'
   and pbt.balance_type_id      = pdb.balance_type_id
   and pbd.balance_dimension_id = pdb.balance_dimension_id
   and pbd.database_item_suffix = '_ASG_YTD';

Line: 122

          select to_number(glb.global_value,'99999999999999999999.99999') -- Bug 5726158
          from   ff_globals_f glb
          where glb.global_name = p_glbvar
          and   p_process_date between glb.effective_start_date and glb.effective_end_date;