APPS.PAY_FI_DPSR SQL Statements

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

Line: 21

	SELECT  pai.*
	FROM pay_action_information pai , pay_assignment_actions paa
	WHERE paa.payroll_action_id = p_payroll_action_id
	AND pai.action_context_id= paa.assignment_action_id
	AND pai.action_context_type= 'AAP'
	AND pai.action_information_category = 'EMEA REPORT INFORMATION'
	AND  pai.action_information1 = 'PYFIDPSA'
	AND pai.action_information3  ='VSPSERIE'
	AND action_information29 ='1'
	ORDER BY pai.action_information2;

Line: 34

	SELECT  pai.*
	FROM pay_action_information pai , pay_assignment_actions paa
	WHERE paa.payroll_action_id = p_payroll_action_id
	AND pai.action_context_id= paa.assignment_action_id
	AND pai.action_context_type= 'AAP'
	AND pai.action_information_category = 'EMEA REPORT INFORMATION'
	AND  pai.action_information1 = 'PYFIDPSA'
	AND pai.action_information3  ='VSPSERIE'
	AND action_information29 ='2'
	AND pai.action_context_id = p_action_context_id
	ORDER BY pai.action_information2;

Line: 51

	SELECT  pai.*
	FROM pay_action_information pai , pay_assignment_actions paa
	WHERE paa.payroll_action_id = p_payroll_action_id
	AND pai.action_context_id= paa.assignment_action_id
	AND pai.action_context_type= 'AAP'
	AND pai.action_information_category = 'EMEA REPORT INFORMATION'
	AND  pai.action_information1 = 'PYFIDPSA'
	AND pai.action_information3  ='VSRAERIE'
	ORDER BY pai.action_information2;

Line: 63

	SELECT  pai.*
	FROM pay_action_information pai , pay_assignment_actions paa
	WHERE paa.payroll_action_id = p_payroll_action_id
	AND pai.action_context_id= paa.assignment_action_id
	AND pai.action_context_type= 'AAP'
	AND pai.action_information_category = 'EMEA REPORT INFORMATION'
	AND  pai.action_information1 = 'PYFIDPSA'
	AND pai.action_information3  =  'VSPSTUKI'
	ORDER BY pai.action_information2;

Line: 75

	SELECT  *
	FROM pay_action_information pai
	WHERE pai.action_context_id= p_payroll_action_id
	AND pai.action_context_type= 'PA'
	AND  pai.action_information_category = 'EMEA REPORT INFORMATION'
	AND  pai.action_information1 = 'PYFIDPSA'
	AND  pai.action_information2    =    'VSPSVYSL'
	ORDER BY pai.action_information4;

Line: 87

	SELECT  *
	FROM pay_action_information pai
	WHERE pai.action_context_id= p_payroll_action_id
	AND pai.action_context_type= 'PA'
	AND  pai.action_information_category = 'EMEA REPORT INFORMATION'
	AND  pai.action_information1 = 'PYFIDPSA'
	AND  pai.action_information2    =    'VSPSVYHT';

Line: 102

			SELECT payroll_action_id
			INTO  l_payroll_action_id
			FROM pay_payroll_actions ppa,
			fnd_conc_req_summary_v fcrs,
			fnd_conc_req_summary_v fcrs1
			WHERE  fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID
			AND fcrs.priority_request_id = fcrs1.priority_request_id
			AND ppa.request_id between fcrs1.request_id  and fcrs.request_id
			AND ppa.request_id = fcrs1.request_id;