The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT request_id
FROM pay_payroll_actions
WHERE payroll_action_id = c_pact_id;
SELECT app.application_short_name, fcp.application_id
FROM fnd_application_vl app,
fnd_concurrent_programs fcp,
fnd_concurrent_requests r
WHERE fcp.concurrent_program_id = r.concurrent_program_id
AND r.request_id = c_request_id
and app.application_id = fcp.application_id;
SELECT template_name --template_type_code
FROM xdo_templates_vl
WHERE template_code = c_templ_code;
SELECT prv.value,
prd.report_type,
prd.report_level,
prd.report_definition_id,
nvl(prd.application_short_name,'PAY'),
prv.definition_type,
prv.report_variable_id
FROM pay_report_groups prg,
pay_payroll_actions ppa,
pay_report_definitions prd,
pay_report_categories prc,
pay_report_category_components prcc,
pay_report_variables prv
WHERE prg.short_name =
nvl(pay_core_utils.get_parameter('REP_GROUP',
ppa.legislative_parameters),
-1)
AND ppa.payroll_action_id = l_payroll_action_id
AND prg.report_group_id = prd.report_group_id
AND prc.short_name =
nvl(pay_core_utils.get_parameter('REP_CAT',
ppa.legislative_parameters),
-1)
AND prc.report_category_id = prcc.report_category_id
AND prcc.report_definition_id = prd.report_definition_id
AND prv.report_variable_id = prcc.style_sheet_variable_id
ORDER BY prd.report_definition_id;
SELECT parameter_value
FROM pay_action_parameters
where parameter_name = p_param_name;
select number_of_copies,
printer,
print_style,
save_output_flag
into copies_buffer,
printer_buffer,
style_buffer,
save_result
from fnd_concurrent_requests
where request_id = fnd_number.canonical_to_number(req_id);
select file_detail_id
from pay_file_details
where source_id = payroll_act_id
or source_id in (select assignment_action_id
from pay_assignment_actions paa
where payroll_action_id = payroll_act_id);
delete from pay_file_details
where file_detail_id = fdetlst(i);
/* This procedure deletes created actions after the submitted requests gets completed */
PROCEDURE standard_deinit(pactid IN NUMBER) IS
remove_act VARCHAR2(10);
SELECT parameter_value
FROM pay_action_parameters
WHERE parameter_name = p_param_name;
request_list.delete;
select pay_core_utils.get_parameter('REMOVE_ACT',
pa1.legislative_parameters)
into remove_act
from pay_payroll_actions pa1
where pa1.payroll_action_id = pactid;
hr_utility.trace ('pay_file_details deleted');