APPS.PQH_GSP_UTILITY dependencies on PER_ALL_PEOPLE_F

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

2326: ---------------------------Get_Emp_Los-----------------------------
2327: --
2328:
2329: Function Get_Emp_Los
2330: (P_Person_id In Per_All_PEOPLE_F.Person_Id%TYPE,
2331: P_Effective_Date In Date)
2332: Return Number is
2333: /* Venkatesh :- The following function is used to determine the Length of Service
2334: for a given Person. It is used in Approval UI */

Line 2338: from Per_All_people_F

2334: for a given Person. It is used in Approval UI */
2335:
2336: Cursor LOS is
2337: Select Months_Between(P_Effective_Date,Start_Date) / 12
2338: from Per_All_people_F
2339: Where Person_id = p_Person_Id
2340: and P_Effective_Date
2341: Between Effective_Start_Date and Effective_End_Date;
2342:

Line 4334: From Per_All_people_F

4330: Return varchar2 is
4331:
4332: Cursor Csr_Person is
4333: Select Full_name
4334: From Per_All_people_F
4335: Where Person_id = P_Person_id
4336: and Nvl(P_Effective_Date, Sysdate)
4337: Between Effective_Start_Date
4338: and Effective_End_Date;

Line 4340: L_Person_name per_All_people_F.Full_name%TYPE;

4336: and Nvl(P_Effective_Date, Sysdate)
4337: Between Effective_Start_Date
4338: and Effective_End_Date;
4339:
4340: L_Person_name per_All_people_F.Full_name%TYPE;
4341: Begin
4342:
4343: If P_Person_id is NOT NULL then
4344: