APPS.PQH_GSP_UTILITY dependencies on PER_ALL_PEOPLE_F

Line 2211: (P_Person_id In Per_All_PEOPLE_F.Person_Id%TYPE,

2207: ---------------------------Get_Emp_Los-----------------------------
2208: --
2209:
2210: Function Get_Emp_Los
2211: (P_Person_id In Per_All_PEOPLE_F.Person_Id%TYPE,
2212: P_Effective_Date In Date)
2213: Return Number is
2214: /* Venkatesh :- The following function is used to determine the Length of Service
2215: for a given Person. It is used in Approval UI */

Line 2219: from Per_All_people_F

2215: for a given Person. It is used in Approval UI */
2216:
2217: Cursor LOS is
2218: Select Months_Between(P_Effective_Date,Start_Date) / 12
2219: from Per_All_people_F
2220: Where Person_id = p_Person_Id
2221: and P_Effective_Date
2222: Between Effective_Start_Date and Effective_End_Date;
2223:

Line 4215: From Per_All_people_F

4211: Return varchar2 is
4212:
4213: Cursor Csr_Person is
4214: Select Full_name
4215: From Per_All_people_F
4216: Where Person_id = P_Person_id
4217: and Nvl(P_Effective_Date, Sysdate)
4218: Between Effective_Start_Date
4219: and Effective_End_Date;

Line 4221: L_Person_name per_All_people_F.Full_name%TYPE;

4217: and Nvl(P_Effective_Date, Sysdate)
4218: Between Effective_Start_Date
4219: and Effective_End_Date;
4220:
4221: L_Person_name per_All_people_F.Full_name%TYPE;
4222: Begin
4223:
4224: If P_Person_id is NOT NULL then
4225: