APPS.GHR_PDI_PKG SQL Statements

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

Line: 14

  SELECT rli.routing_list_id
        ,rli.name
        ,pdh.routing_seq_number
        ,pdh.pd_routing_history_id
  FROM   ghr_routing_lists      rli
        ,ghr_pd_routing_history pdh
  WHERE  pdh.position_description_id = p_position_description_id
  AND    pdh.routing_list_id = rli.routing_list_id
  ORDER BY pdh.pd_routing_history_id DESC;

Line: 32

  SELECT pdh.pd_routing_history_id
  FROM   ghr_pd_routing_history  pdh
  WHERE  pdh.position_description_id = p_position_description_id
  ORDER BY pdh.pd_routing_history_id DESC;

Line: 39

  SELECT   rlm.seq_number
          ,rlm.user_name
          ,rlm.groupbox_id
  FROM     ghr_routing_list_members rlm
  WHERE    rlm.routing_list_id = p_routing_list_id
  AND      rlm.seq_number      > p_seq_number
  ORDER BY rlm.seq_number asc;

Line: 95

  select pdh.groupbox_id
        ,pdh.user_name
  from   ghr_pd_routing_history pdh
  where  pdh.position_description_id = p_position_description_id
  order by pdh.pd_routing_history_id desc;

Line: 102

  select pdh.groupbox_id
  from   ghr_pd_routing_history pdh
  where  pdh.position_description_id = p_position_description_id
  and    pdh.user_name = l_user_name
  and    pdh.groupbox_id is not NULL
  and    not exists (select 1
                     from   ghr_pd_routing_history pdh2
                     where  pdh2.position_description_id = p_position_description_id
                     and    pdh2.user_name <> l_user_name
                     and    pdh2.pd_routing_history_id > pdh.pd_routing_history_id)
  order by pdh.pd_routing_history_id asc;

Line: 115

  select pei.pei_information4 initiator_flag
        ,pei.pei_information5 requester_flag
        ,pei.pei_information6 authorizer_flag
        ,pei.pei_information7 personnelist_flag
        ,pei.pei_information8 approver_flag
        ,pei.pei_information9 reviewer_flag
  from   per_people_extra_info pei
        ,fnd_user              usr
  where  usr.user_name        = l_user_name
  and    pei.person_id        = usr.employee_id
  and    pei.information_type = 'GHR_US_PER_WF_ROUTING_GROUPS'
  and    pei.pei_information3 = p_routing_group_id;

Line: 129

  select gru.initiator_flag
        ,gru.authorizer_flag
        ,gru.personnelist_flag
        ,gru.approver_flag
        ,gru.reviewer_flag
	,gru.requester_flag
  from   ghr_groupbox_users gru
  where  gru.groupbox_id = l_groupbox_id
  and    gru.user_name   = p_user_name;