APPS.PAY_FI_MTRR SQL Statements

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

Line: 63

				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' ;

Line: 73

		      select data_source_code
		      from   xdo_templates_b
                      where  template_code = p_template_name
		      and    application_short_name = 'PAY';

Line: 88

					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;

Line: 124

					 SELECT  trim(rg_mtrr_rpt.action_information4)||'  '||trim(rg_mtrr_rpt.action_information4)
					 INTO l_Wage_payment_month
					 FROM dual;

Line: 708

				   SELECT  trim(rg_mtrr_rpt.action_information4)||'  '||trim(rg_mtrr_rpt.action_information4)
					 INTO l_Wage_payment_month
					 FROM dual;