APPS.PAY_KR_YEA20050101_PKG SQL Statements

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

Line: 97

	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: 151

          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;

Line: 507

			--              Also, p_yea_info.educ_exp_tax_exem may still change. Hence, updated value of educ_exp_tax_exem
			--              would be added to l_cuml_special_exem later.
			--
			p_yea_info.educ_exp_tax_exem := p_yea_info.educ_exp_tax_exem + p_yea_info.ee_occupation_educ_exp2005 ;