APPS.PAY_KR_YEA20040101_PKG SQL Statements

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

Line: 96

	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 pbd.legislation_code     = 'KR'
           and pdb.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: 150

          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;