APPS.PA_CI_ACTIONS_UTIL SQL Statements

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

Line: 8

   select 'Y'
   from pa_ci_comments
   where ci_action_id = p_ci_action_id
   and type_code <> 'REQUESTOR';

Line: 30

   select pci.last_action_number
   from pa_control_items pci
   where pci.ci_id = p_ci_id
   for update of pci.last_action_number;

Line: 46

	UPDATE pa_control_items
	set last_action_number = l_next_number + 1
	where ci_id = p_ci_id;

Line: 61

    select person_party_id from fnd_user
    where user_id = p_user_id;

Line: 64

    select customer_id from fnd_user
    where user_id = p_user_id; */

Line: 70

    select pap.party_id
     from per_all_people_f pap,
          fnd_user fu
     where fu.user_id = p_user_id
     and fu.employee_id = pap.person_id
     and trunc(sysdate) between trunc(pap.effective_start_date) and trunc(pap.effective_end_date) ;

Line: 76

    /*select h.party_id
    from hz_parties h
    ,fnd_user f
    where h.orig_system_reference = CONCAT('PER:',f.employee_id)
    and f.user_id = p_user_id;*/

Line: 124

       select party_id
       from per_all_people_f p
       where p.person_id = l_resource_id
       and trunc(p_date) between trunc(p.effective_start_date) and trunc(p.effective_end_date);

Line: 191

   select count(*)
     into total_act
     from pa_ci_actions
    where ci_id = p_ci_id and
          status_code = 'CI_ACTION_OPEN';

Line: 214

  select open_action_num
  from pa_control_items
  where ci_id = p_ci_id;

Line: 242

	select ci_action_id
	from pa_ci_actions
	where source_ci_action_id is null
	start with ci_action_id = p_ci_action_id
	connect by prior source_ci_action_id = ci_action_id;