APPS.PAY_NO_RSER SQL Statements

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

Line: 64

				SELECT	  *
				FROM	PAY_ACTION_INFORMATION
			  	WHERE	 ACTION_CONTEXT_TYPE = 'PA'
			  	AND	ACTION_CONTEXT_ID =  csr_v_pa_id
				AND ACTION_INFORMATION_CATEGORY='EMEA REPORT INFORMATION'
				AND  ACTION_INFORMATION1='PYNORSEA';

Line: 75

				SELECT	  *
				FROM	PAY_ACTION_INFORMATION
			  	WHERE	 ACTION_CONTEXT_TYPE = 'PA'
			  	AND	ACTION_CONTEXT_ID =  csr_v_pa_id
				AND ACTION_INFORMATION_CATEGORY= 'EMEA REPORT INFORMATION'
				AND  ACTION_INFORMATION1='PYNORSEA'
				AND  ACTION_INFORMATION2='M';

Line: 87

				SELECT	  SUM(action_information6)  Witholding_Tax,  SUM(action_information7)  u_contribution_basis, SUM(action_information8)  o_contribution_basis
				, SUM(action_information20)  fe_spr_contribution_basis,  SUM(action_information21) fe_spr_calc_contribution
				,  SUM(action_information25)   fe_fma_calc_contribution ,  SUM(action_information11)  u_calc_contribution, SUM(action_information12)  o_calc_contribution
				, SUM(action_information26)  lu_el_used , SUM(action_information27)  lu_el_used_bimonth  , SUM(action_information23)  no_month
				FROM	PAY_ACTION_INFORMATION
			  	WHERE	 ACTION_CONTEXT_TYPE = 'PA'
			  	AND	ACTION_CONTEXT_ID =  csr_v_pa_id
				AND ACTION_INFORMATION_CATEGORY= 'EMEA REPORT INFORMATION'
				AND  ACTION_INFORMATION1='PYNORSEA'
				AND  ACTION_INFORMATION2='M';

Line: 112

					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;