APPS.PAY_NL_IZA_REPORT SQL Statements

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

Line: 29

select 'EUR' currency , iza.payroll_center ,
       iza.province_code||' '||hr_general.decode_lookup('NL_IZA_PROVINCE',iza.province_code) province,
       lpad(employer_number,3,'0') employer_number , lpad(sub_employer_number,3,'0') sub_employer_number
from pay_nl_iza_upld_status iza
where iza.business_group_id = p_bg_id
and iza.organization_id = p_employer_id
and iza.process_year_month = last_day(to_date(p_process_month,'MMYYYY'));

Line: 38

select lpad(iza.employer_number,3,'0')||lpad(iza.sub_employer_number,3,'0')||'-'||lpad(iza.employee_number,9,'0') exchange_number,iza.process_status,
iza.employee_name name,
iza.date_of_birth dob,
iza.participant_number participant_number,
iza.contribution_1 iza_amt_1,iza.contribution_2 iza_amt_2,
iza.correction_contribution_1 corr_amt_1,iza.correction_contribution_2 corr_amt_2,
iza.date_correction_1,iza.date_correction_2,
decode(iza.process_status,'MISSING',hr_general.decode_lookup('NL_IZA_REJECT_REASON',iza.process_status),hr_general.decode_lookup('NL_IZA_REJECT_REASON',iza.reject_reason)) explanation
from pay_nl_iza_upld_status iza
where iza.business_group_id = p_bg_id
and iza.organization_id = p_employer_id
and iza.process_year_month = last_day(to_date(p_process_month,'MMYYYY'));

Line: 116

 	PAY_NL_XDO_REPORT.vXMLTable.DELETE;

Line: 328

	SELECT program_name
	INTO l_file_name
	FROM fnd_lobs
	WHERE file_id = p_file_id;

Line: 333

	-- the delete will ensure that the patch is rerunnable
	DELETE FROM per_gb_xdo_templates
	WHERE file_name = l_file_name AND
	effective_start_date = l_start_date AND
	effective_end_date = l_end_date;

Line: 339

	INSERT INTO per_gb_xdo_templates
	(file_id,
	file_name,
	file_description,
	effective_start_date,
	effective_end_date)
	SELECT p_file_id, l_file_name, 'Template for year 0001-4712',
	l_start_date, l_end_date
	FROM fnd_lobs
	WHERE file_id = p_file_id;