DBA Data[Home] [Help]

APPS.PQH_GSP_PROCESS_LOG dependencies on PER_ALL_PEOPLE_F

Line 85: Per_All_People_F Person

81: 'N',
82: 'CURR'),
83: Person.Full_name
84: From Per_All_Assignments_F Assgt,
85: Per_All_People_F Person
86: Where Assignment_id = P_Txn_id
87: and P_Effective_Date
88: Between Assgt.Effective_Start_Date
89: and Assgt.Effective_End_Date

Line 110: l_Person_Name Per_All_People_F.Full_name%TYPE;

106:
107: L_Grade_Ladder_Name Ben_Pgm_F.Name%TYPE;
108: l_Grade_name Per_Grades.Name%TYPE;
109: l_Step_name Per_Spinal_Points.Spinal_POint%TYPE;
110: l_Person_Name Per_All_People_F.Full_name%TYPE;
111: L_LOG_ID Pqh_Process_Log.Process_Log_Id%TYPE;
112: L_MASTER_LOG_ID Pqh_Process_Log.MASTER_PROCESS_LOG_ID%TYPE;
113: l_Message_Type Varchar2(25);
114: L_Log_Context Pqh_Process_log.Log_Context%TYPE;