APPS.PAY_SE_CWCR SQL Statements

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

Line: 34

	SELECT mod(l_number,10) INTO l_digit(l_count) from dual;

Line: 39

   SELECT floor(l_number) INTO l_digit(l_number) from dual;

Line: 87

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

Line: 97

				SELECT	  *
				FROM	PAY_ACTION_INFORMATION
			  	WHERE	 ACTION_CONTEXT_TYPE = 'PA'
			  	AND ACTION_CONTEXT_ID =  csr_v_pa_id
				AND  ACTION_INFORMATION1='PYSECWCA'
				AND  ACTION_INFORMATION2='CWC1';

Line: 108

				SELECT	  *
				FROM	PAY_ACTION_INFORMATION
			  	WHERE	 ACTION_CONTEXT_TYPE = 'PA'
			  	AND ACTION_CONTEXT_ID =  csr_v_pa_id
				AND  ACTION_INFORMATION1='PYSECWCA'
				AND  ACTION_INFORMATION2='CWC2'
				ORDER BY ACTION_INFORMATION10 asc , ACTION_INFORMATION3  asc ;

Line: 118

				SELECT	  *
				FROM	PAY_ACTION_INFORMATION
			  	WHERE	 ACTION_CONTEXT_TYPE = 'PA'
			  	AND ACTION_CONTEXT_ID =  csr_v_pa_id
				AND  ACTION_INFORMATION1='PYSECWCA'
				AND  ACTION_INFORMATION2='CWC3'
				AND  ACTION_INFORMATION3  = csr_v_month
				AND  ACTION_INFORMATION10  = csr_v_year	;

Line: 129

				SELECT	  *
				FROM	PAY_ACTION_INFORMATION
			  	WHERE	 ACTION_CONTEXT_TYPE = 'PA'
			  	AND ACTION_CONTEXT_ID =  csr_v_pa_id
				AND  ACTION_INFORMATION1='PYSECWCA'
				AND  ACTION_INFORMATION2='CWC4'
				AND  ACTION_INFORMATION3  = csr_v_month
				AND  ACTION_INFORMATION10  = csr_v_year	;

Line: 140

				SELECT	  *
				FROM	PAY_ACTION_INFORMATION
			  	WHERE	 ACTION_CONTEXT_TYPE = 'PA'
			  	AND ACTION_CONTEXT_ID =  csr_v_pa_id
				AND  ACTION_INFORMATION1='PYSECWCA'
				AND  ACTION_INFORMATION2='CWC5'
				AND  ACTION_INFORMATION3  = csr_v_month
				AND  ACTION_INFORMATION10  = csr_v_year	;

Line: 157

					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;