eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_RANK_UTILITY SQL Statements

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

Line: 18


	select information12
	  into l_use_rank
	  from ben_copy_entity_results
	 where copy_entity_txn_id = p_copy_entity_txn_id
	   and table_alias = 'PGI' ;

Line: 42


	select rp.benefit_action_id
	  from pqh_rank_processes rp
     where rp.pgm_id = p_pgm_id
       and rp.per_in_ler_id = p_per_in_ler_id;

Line: 48


	select rp.benefit_action_id
	  from pqh_rank_processes rp
     where rp.pgm_id = p_pgm_id
       and rp.per_in_ler_id = p_per_in_ler_id
	   and rp.pl_id = p_pl_id ;

Line: 88


procedure update_proposed_rank ( p_proposed_rank    in number
                             	,p_per_in_ler_id	in number
                                ,p_pgm_id           in number
                                ,p_pl_id            in number   )
is
l_proc constant varchar2(72) := g_package||'.update_proposed_rank';

Line: 101


	select rpa.rank_process_approval_id
          ,rpa.rank_process_id
	   ,rpa.object_version_number
	  from pqh_rank_processes rp
	      ,pqh_rank_process_approvals rpa
     where rp.pgm_id = p_pgm_id
       and rp.per_in_ler_id = p_per_in_ler_id
       and rp.rank_process_id = rpa.rank_process_id;

Line: 111


	select rpa.rank_process_approval_id
          ,rpa.rank_process_id
	  ,rpa.object_version_number
	  from pqh_rank_processes rp
	      ,pqh_rank_process_approvals rpa
     where rp.pgm_id = p_pgm_id
       and rp.per_in_ler_id = p_per_in_ler_id
       and rp.rank_process_id = rpa.rank_process_id
       and rp.pl_id = p_pl_id ;

Line: 144


PQH_RANK_PROCESS_APPROVAL_API.update_rank_process_approval
  (p_effective_date            =>l_date
  ,p_rank_process_approval_id  =>l_rank_process_approval_id
  ,p_rank_process_id           =>l_rank_process_id
  ,p_approval_date             =>l_date
  ,p_proposed_rank             =>p_proposed_rank
  ,p_object_version_number     =>l_object_version_number
  );

Line: 158


end update_proposed_rank ;

Line: 164


procedure update_proposed_rank ( p_proposed_rank    in number
                             	,p_assignment_id	in number
                                ,p_life_event_dt   in date
                                ,p_pgm_id           in number
                                ,p_pl_id            in number   )
is
l_proc constant varchar2(72) := g_package||'.update_proposed_rank';

Line: 178


	select rpa.rank_process_approval_id
          ,rpa.rank_process_id
	   ,rpa.object_version_number
	  from pqh_rank_processes rp
	      ,pqh_rank_process_approvals rpa
     where rp.pgm_id = p_pgm_id
       and rp.assignment_id = p_assignment_id
       and rp.PROCESS_DATE = p_life_event_dt
       and rp.rank_process_id = rpa.rank_process_id;

Line: 189


	select rpa.rank_process_approval_id
          ,rpa.rank_process_id
	  ,rpa.object_version_number
	  from pqh_rank_processes rp
	      ,pqh_rank_process_approvals rpa
     where rp.pgm_id = p_pgm_id
       and rp.assignment_id = p_assignment_id
       and rp.PROCESS_DATE = p_life_event_dt
       and rp.rank_process_id = rpa.rank_process_id
	   and rp.pl_id = p_pl_id ;

Line: 223


PQH_RANK_PROCESS_APPROVAL_API.update_rank_process_approval
  (p_effective_date            =>l_date
  ,p_rank_process_approval_id  =>l_rank_process_approval_id
  ,p_rank_process_id           =>l_rank_process_id
  ,p_approval_date             =>l_date
  ,p_proposed_rank             =>p_proposed_rank
  ,p_object_version_number     =>l_object_version_number
  );

Line: 237


end update_proposed_rank ;

Line: 254


	select rpa.system_rank
	  from pqh_rank_processes rp
	      ,pqh_rank_process_approvals rpa
     where rp.pgm_id = p_pgm_id
       and rp.per_in_ler_id = p_per_in_ler_id
       and rp.rank_process_id = rpa.rank_process_id;

Line: 262


	select rpa.system_rank
	  from pqh_rank_processes rp
	      ,pqh_rank_process_approvals rpa
     where rp.pgm_id = p_pgm_id
       and rp.per_in_ler_id = p_per_in_ler_id
       and rp.rank_process_id = rpa.rank_process_id
	   and rp.pl_id = p_pl_id ;

Line: 271


	select rpa.proposed_rank
	  from pqh_rank_processes rp
	      ,pqh_rank_process_approvals rpa
     where rp.pgm_id = p_pgm_id
       and rp.per_in_ler_id = p_per_in_ler_id
       and rp.rank_process_id = rpa.rank_process_id;

Line: 279


	select rpa.proposed_rank
	  from pqh_rank_processes rp
	      ,pqh_rank_process_approvals rpa
     where rp.pgm_id = p_pgm_id
       and rp.per_in_ler_id = p_per_in_ler_id
       and rp.rank_process_id = rpa.rank_process_id
	   and rp.pl_id = p_pl_id ;

Line: 349


	select rp.total_score
	  from pqh_rank_processes rp
     where rp.pgm_id = p_pgm_id
       and rp.per_in_ler_id = p_per_in_ler_id;

Line: 355


	select rp.total_score
	  from pqh_rank_processes rp
     where rp.pgm_id = p_pgm_id
       and rp.per_in_ler_id = p_per_in_ler_id
       and rp.pl_id = p_pl_id ;

Line: 403


    select 'Y'
      into l_present_flag
      from ben_pgm_f pgm
          ,ben_pgm_extra_info pgmei
    where pgm.business_group_id = p_business_group_id
      and pgm.pgm_id = pgmei.pgm_id
      and pgmei.information_type = 'PQH_GSP_EXTRA_INFO'
      and pgmei.pgi_information2 = 'Y'  -- Verify and confirm
      and rownum < 2 ;

Line: 438


            select NVL(pgi_information1,'NOT_FOUND')   -- Verify and confirm
              into l_option_value
              from ben_pgm_extra_info pgmei
             where pgmei.pgm_id = p_pgm_id
               and pgmei.information_type = 'PQH_GSP_EXTRA_INFO'
               and rownum < 2 ;

Line: 452


            select NVL(pgi_information2,'N')   -- Verify and confirm
              into l_option_value
              from ben_pgm_extra_info pgmei
             where pgmei.pgm_id = p_pgm_id
               and pgmei.information_type = 'PQH_GSP_EXTRA_INFO'
               and rownum < 2 ;

Line: 465


            select NVL(pgi_information3,'NOT_FOUND')   -- Verify and confirm
              into l_option_value
              from ben_pgm_extra_info pgmei
             where pgmei.pgm_id = p_pgm_id
               and pgmei.information_type = 'PQH_GSP_EXTRA_INFO'
               and rownum < 2 ;

Line: 515


 select fff.function_id
 from   fnd_form_functions_vl fff
 where  fff.function_name = p_functionName;

Line: 523


 SELECT wrpv.display_name displayName
 FROM   wf_runnable_processes_v wrpv
 WHERE  wrpv.item_type    = p_itemType
 AND    wrpv.process_name = p_processName;

Line: 558


   Select object_version_number
     into l_ovn
     From ben_elig_per_elctbl_chc
    Where elig_per_elctbl_chc_id  = p_elctbl_chc_id;

Line: 563


    ben_elig_per_elc_chc_api.update_elig_per_elc_chc (
        p_elig_per_elctbl_chc_id  => p_elctbl_chc_id
       ,p_in_pndg_wkflow_flag     => 'Y'
       ,p_object_version_number   => l_ovn
       ,p_effective_date          => sysdate);

Line: 582


      select pqh_workflow_item_key_s.nextval into l_itemKey from dual;

Line: 597


               ,p_selected_person_id     => p_person_id
               ,p_item_type              => p_itemtype
               ,p_item_key               => l_itemkey
               ,p_process_name           => p_processName );