APPS.PAY_CA_T4_XML SQL Statements

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

Line: 131

select substr(fdi.user_name,27,2) code,
       fai.value                  value
from ff_archive_items         fai,
     ff_database_items        fdi,
     ff_archive_item_contexts faic,
     ff_contexts              fc
where fai.user_entity_id  = fdi.user_entity_id
and   fai.archive_item_id = faic.archive_item_id
and   fc.context_id       = faic.context_id
and   fc.context_name     = 'JURISDICTION_CODE'
and   faic.context        = p_prov
and   fai.context1        = p_aa_id
and   nvl((trim(fai.value)),'0') <> '0'
and   fdi.user_name in (
'CAEOY_T4_OTHER_INFO_AMOUNT30_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT31_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT32_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT33_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT34_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT35_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT36_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT37_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT38_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT39_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT40_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT41_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT42_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT43_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT53_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT66_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT67_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT68_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT69_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT70_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT71_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT72_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT73_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT74_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT75_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT76_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT77_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT78_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT79_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT80_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT81_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT82_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT83_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT84_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT85_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT86_PER_JD_GRE_YTD',
'CAEOY_T4_OTHER_INFO_AMOUNT87_PER_JD_GRE_YTD')
order by substr(fdi.user_name,27,2);

Line: 187

   g_other_info_list.delete;

Line: 231

         select count(1) into lv_ei_display_flag
         from 	ff_archive_items fai,
              	ff_database_items fdi
         where fai.context1 = p_aa_id
           and 	fai.user_entity_id=fdi.user_entity_id
           and 	fdi.user_name='CAEOY_PROVINCE_OF_EMPLOYMENT';

Line: 272

 select paa1.assignment_action_id, -- archiver asg action
        ppa1.payroll_action_id,    -- archiver pact
        pay_ca_t4_reg.get_parameter('TYPE',ppa.legislative_parameters),
        pay_ca_t4_reg.get_parameter('PRINT',ppa.legislative_parameters),
        pay_ca_t4_reg.get_parameter('INSTRUCTIONS',ppa.legislative_parameters),
        substr(paa.serial_number,1,2)
 from  pay_assignment_actions paa,
       pay_payroll_actions ppa,
       pay_assignment_actions paa1,
       pay_payroll_actions ppa1
 where ppa.payroll_action_id = paa.payroll_action_id
 and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
 and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
 and fnd_number.canonical_to_number(substr(paa.serial_number,3,14)) = paa1.assignment_action_id
 and paa1.payroll_action_id = ppa1.payroll_action_id
 and ((ppa1.report_type   = decode(ppa.report_type,'T4_XML','T4','PAYCAT4AMPDF','CAEOY_T4_AMEND_PP')
      and ppa.report_type <> 'PAYCAT4CLPDF') or (ppa.report_type = 'PAYCAT4CLPDF' and
       ppa1.report_type in ('T4_XML','PAYCAT4AMPDF')))
 and ppa1.action_type   = 'X'
 and ppa1.action_status = 'C'
 and ppa1.effective_date = ppa.effective_date;

Line: 297

 select ppa.report_type
   from pay_payroll_actions ppa
  where ppa.payroll_action_id = c_payroll_action_id;

Line: 302

 select paa2.assignment_action_id,paa2.payroll_action_id
   from pay_assignment_actions paa1,
        pay_assignment_actions paa2
  where paa1.assignment_action_id = c_assignment_action_id
    and substr(paa1.serial_number,3,14) = paa2.assignment_action_id
    and paa1.assignment_id = paa2.assignment_id;

Line: 423

  select
   meaning
  from
    hr_lookups
  where
   lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
   lookup_code = p_lookup_code;

Line: 453

  select paa.payroll_action_id
   into  l_pa_id
  from pay_assignment_actions paa
   where paa.assignment_action_id = p_assignment_action_id;

Line: 663

select information_value
from pay_ca_legislation_info
where information_type = 'MAX_CPP_EARNINGS'
and to_date(lv_year ||'/01/01','YYYY/MM/DD')
               between start_date and end_date;

Line: 670

select information_value
from pay_ca_legislation_info
where information_type = 'MAX_EI_EARNINGS'
and to_date(lv_year ||'/01/01','YYYY/MM/DD')
               between start_date and end_date;

Line: 677

select information_value
from pay_ca_legislation_info
where information_type = 'MAX_PPIP_EARNINGS'
and to_date(lv_year ||'/01/01','YYYY/MM/DD')
               between start_date and end_date;

Line: 684

select name
from hr_all_organization_units hou,
     pay_assignment_actions    paa
where paa.assignment_action_id = p_aa_id
and   paa.tax_unit_id    = hou.organization_id;

Line: 1538

       select translate(ltrim(value),',',' ')
        into TEMP_UTL
        from v$parameter
       where name = 'utl_file_dir';

Line: 1544

        select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)
          into g_temp_dir
          from dual ;

Line: 1573

select tag
from fnd_lookup_values
where lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
and lookup_code = SUBSTR(USERENV('LANGUAGE'),
                         INSTR(USERENV('LANGUAGE'), '.') + 1)
and language = 'US';