APPS.PQH_GSP_PROCESS_LOG SQL Statements

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

Line: 23

Procedure Insert_Log
(p_module_cd             IN      Varchar2
,p_txn_id                IN      Number
,p_log_context           IN      Varchar2
,p_master_process_log_id IN      Number
,p_message_text          IN      Varchar2
,p_message_type_cd       IN      Varchar2
,P_Information1          IN      Varchar2
,P_Information2          IN      Varchar2
,P_Information3          IN      Varchar2) IS

L_Ovn                 Pqh_Process_Log.Object_Version_Number%TYPE;

Line: 57

End Insert_Log;

Line: 67

Select GRADE_LADDER_NAME,
       GRADE_NAME,
       STEP_NAME,
       FULL_NAME
  From PQH_GSP_ELECTABLE_CHOICE_V
 Where Elig_Per_Elctbl_Chc_id = P_Txn_Id;

Line: 75

 Select Decode(Assgt.Grade_ladder_Pgm_id, NULL, NULL, Ben_Batch_Utils.GET_PGM_NAME(Assgt.Grade_ladder_Pgm_id,
                                     Assgt.BUSINESS_GROUP_ID,
	                             P_Effective_Date)),
	Hr_general.Decode_Grade(Grade_Id),
        pqh_gsp_utility.Get_Step_Dtls(Assgt.Assignment_id,
                                      P_Effective_Date,
                                      'N',
                                      'CURR'),
        Person.Full_name
   From Per_All_Assignments_F Assgt,
        Per_All_People_F Person
  Where Assignment_id = P_Txn_id
    and P_Effective_Date
Between Assgt.Effective_Start_Date
    and Assgt.Effective_End_Date
    and Assgt.Person_Id = Person.Person_id
    and P_Effective_Date
Between Person.Effective_Start_Date
    and Person.Effective_End_Date;

Line: 96

 Select information5
   From ben_copy_entity_results
  Where copy_entity_txn_id = P_Txn_id
    and table_alias ='PGM';

Line: 102

Select Process_Log_Id
  From Pqh_Process_Log
 Where Txn_id    = P_Master_txn_Id
   and MODULE_CD = P_Module_Cd;

Line: 163

Insert_log(p_module_cd             => P_Module_Cd
          ,p_txn_id                => P_Txn_id
          ,p_log_context           => l_Log_Context
          ,p_master_process_log_id => l_Master_log_id
          ,p_message_text          => NVL(p_message_text,Hr_general.Decode_Lookup('PQH_GSP_GEN_PROMPTS','CMPSUC'))
          ,p_message_type_cd       => l_Message_Type
          ,P_Information1	   => L_Grade_Ladder_name
          ,P_Information2          => L_Grade_name
          ,P_Information3          => L_Step_Name);