[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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_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')
order by substr(fdi.user_name,27,2);
g_other_info_list.delete;
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 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 = 'T4'
and ppa1.action_type = 'X'
and ppa1.action_status = 'C'
and ppa1.effective_date = ppa.effective_date;
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;
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;
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;
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;
select translate(ltrim(value),',',' ')
into TEMP_UTL
from v$parameter
where name = 'utl_file_dir';
select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)
into g_temp_dir
from dual ;
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';