APPS.PAY_DK_EINR SQL Statements

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

Line: 26

	SELECT  pai.*
	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 = 'PYDKEINA'
	AND pai.action_information3  ='1000';

Line: 37

	SELECT  pai.*
	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 = 'PYDKEINA'
	AND pai.action_information3  ='2001'
--	AND action_information29 ='2'
--	AND pai.action_context_id = p_action_context_id
	ORDER BY pai.action_information30;

Line: 53

	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 = 'PYDKEINA'
	AND pai.action_information3  ='2101'
  AND pai.action_information11=p_se_no
	order by pai.action_information30;

Line: 68

	SELECT  pai.*
	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 = 'PYDKEINA'
	AND pai.action_information3  =  '5000'
and pai.action_information11  =  p_se_no
        order by pai.action_information30; /* 9587046 */

Line: 80

	SELECT  pai.*
	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 = 'PYDKEINA'
	AND pai.action_information3  =  '5000R'
	AND pai.action_information25 = p_payroll_id
	AND pai.action_information9=p_employement_type
	AND pai.action_information8=p_green_land_code /* 8847591 */
	AND pai.action_information24=p_time_period_id
  AND pai.action_information11=p_se_no;

Line: 96

	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 = 'PYDKEINA'
	AND  pai.action_information3 = '6000'
	AND  pai.action_information25 = p_payroll_id
	AND pai.action_information26=p_employement_type
	AND pai.action_information24=p_time_period_id
	AND pai.action_information27=p_green_land_code /* 8847591 */
  AND pai.action_information11=p_se_no
	order by pai.action_information30;

Line: 113

	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 = 'PYDKEINA'
	AND  pai.action_information3 = '8001'
	AND  pai.action_information5 = p_assignment_id
	AND  pai.action_information25 = p_payroll_id
	AND pai.action_information26=p_employement_type
	AND pai.action_information24=p_time_period_id
	AND pai.action_information27=p_green_land_code /* 8847591 */
	ORDER BY pai.action_information30;

Line: 130

	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 = 'PYDKEINA'
	AND  pai.action_information3 = '8001R'
	AND  pai.action_information5 = p_assignment_id
	AND  pai.action_information25 = p_payroll_id
	AND pai.action_information26=p_employement_type
	AND pai.action_information24=p_time_period_id
	AND pai.action_information27=p_green_land_code /* 8847591 */
	ORDER BY pai.action_information30;

Line: 147

	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 = 'PYDKEINA'
	AND  pai.action_information3 = '6001'
	AND  pai.action_information5 = p_assignment_id
	AND nvl(pai.action_information29, 'N') <> 'Y'
	AND  pai.action_information25 = p_payroll_id
	AND pai.action_information26=p_employement_type
	AND pai.action_information24=p_time_period_id
	AND pai.action_information27=p_green_land_code /* 8847591 */
	ORDER BY pai.action_information30;

Line: 165

	SELECT  distinct pai.action_information5,pai.action_information3,action_context_id /* 9587046R */
	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 = 'PYDKEINA'
	AND  pai.action_information3 = '6001'
	AND nvl(pai.action_information29, 'N') = 'Y'
	AND  pai.action_information25 = p_payroll_id
	AND pai.action_information26=p_employement_type
	AND pai.action_information24=p_time_period_id
	AND pai.action_information27=p_green_land_code  /* 8847591 */
  AND pai.action_information11=p_se_no
	ORDER BY pai.action_information3,action_context_id DESC; /* 9587046R */

Line: 183

	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 = 'PYDKEINA'
	AND  pai.action_information3 = '6001'
	AND  pai.action_information5 = p_assignment_id
	AND nvl(pai.action_information29, 'N') = 'Y'
	AND  pai.action_information25 = p_payroll_id
	AND pai.action_information26=p_employement_type
	AND pai.action_information24=p_time_period_id
	AND pai.action_information27=p_green_land_code /* 8847591 */
	ORDER BY pai.action_information30;

Line: 201

	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 = 'PYDKEINA'
	AND  pai.action_information3 = '6000R'
	AND pai.action_information5 = p_assignment_id
	AND  pai.action_information25 = p_payroll_id
	AND pai.action_information26=p_employement_type
	AND pai.action_information24=p_time_period_id
	AND pai.action_information27=p_green_land_code /* 8847591 */
  AND  pai.action_information11=p_se_no  /* 10367494 */
	order by pai.action_information30;

Line: 219

	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 = 'PYDKEINA'
	AND  pai.action_information3 = '6002'
	AND  pai.action_information5 = p_assignment_id
	AND  pai.action_information25 = p_payroll_id
	AND pai.action_information26=p_employement_type
	AND pai.action_information24=p_time_period_id
	AND pai.action_information27=p_green_land_code; /* 8847591 */

Line: 235

	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 = 'PYDKEINA'
	AND  pai.action_information3 = '6003'
	AND  pai.action_information5 = p_assignment_id
	AND  pai.action_information25 = p_payroll_id
	AND pai.action_information26=p_employement_type
	AND pai.action_information24=p_time_period_id
	AND pai.action_information27=p_green_land_code; /* 8847591 */

Line: 251

	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 = 'PYDKEINA'
	AND  pai.action_information3 = '6004'
	AND  pai.action_information5 = p_assignment_id
	AND  pai.action_information25 = p_payroll_id
	AND pai.action_information26=p_employement_type
	AND pai.action_information24=p_time_period_id
	AND pai.action_information27=p_green_land_code; /* 8847591 */

Line: 267

	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 = 'PYDKEINA'
	AND  pai.action_information3 = '6005'
	AND  pai.action_information5 = p_assignment_id
	AND  pai.action_information25 = p_payroll_id
	AND pai.action_information26=p_employement_type
	AND pai.action_information24=p_time_period_id
	AND pai.action_information27=p_green_land_code /* 8847591 */
	ORDER BY pai.action_information30; --14095960

Line: 285

	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 = 'PYDKEINA'
	AND  pai.action_information3 = '6102'
	AND  pai.action_information5 = p_assignment_id
	AND  pai.action_information25 = p_payroll_id
	AND pai.action_information26=p_employement_type
	AND pai.action_information24=p_time_period_id
	AND pai.action_information27=p_green_land_code
	order by pai.action_information30; --13630274 /* 8847591 */

Line: 303

	SELECT  pai.*
	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 = 'PYDKEINA'
	AND  pai.action_information3 = '9999';

Line: 321

			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;