APPS.PSP_ENC_CRT_XML SQL Statements

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

Line: 28

				SELECT segment1
		INTO	 l_project_number
		FROM   pa_projects_all
		WHERE  project_id = p_project_id;

Line: 33

				SELECT task_number
		INTO	 l_task_number
		FROM 	 PA_TASKS
		WHERE    task_id = p_task_id;

Line: 38

		SELECT award_number
		INTO	 l_award_number
		FROM	 gms_awards_all
		WHERE  award_id = p_award_id;

Line: 43

				SELECT name
		INTO	 l_org_name
		FROM	 hr_all_organization_units
		WHERE  organization_id = p_expenditure_organization_id;

Line: 78

   select lookup_code, meaning
     from fnd_lookup_values_vl
    where lookup_type = 'PSP_SCHEDULE_TYPES'
      and enabled_flag = 'Y'
      and sysdate between start_date_active and nvl(end_date_active, fnd_date.canonical_to_date('4000/01/31'));

Line: 123

 select to_char(max(date_earned), l_date_mask)
   from pay_payroll_actions
  where payroll_id = p_payroll_id
    and action_type = 'R'
    and action_status = 'C';

Line: 140

   select request_id
     from psp_enc_processes
    where payroll_action_id = p_payroll_action_id
      and request_id <> p_request_id
      and process_code in ( 'CEL', 'LET');