APPS.PA_OTC_API dependencies on PER_PEOPLE_F

Line 6373: -- P_Approver_Id - Per_People_F.Person_Id%TYPE

6369: -- name is validated against pa_exp_ovrrde_approver_v view.
6370: --
6371: -- Parameters :
6372: -- IN
6373: -- P_Approver_Id - Per_People_F.Person_Id%TYPE
6374: --
6375: -- OUT
6376: -- X_Approver_Id - Per_People_F.Person_Id%TYPE
6377: -- X_Error_Type - Varchar2

Line 6376: -- X_Approver_Id - Per_People_F.Person_Id%TYPE

6372: -- IN
6373: -- P_Approver_Id - Per_People_F.Person_Id%TYPE
6374: --
6375: -- OUT
6376: -- X_Approver_Id - Per_People_F.Person_Id%TYPE
6377: -- X_Error_Type - Varchar2
6378: -- X_Error_Code - Varchar2
6379: /* ------------------------------------------------------------------------*/
6380:

Line 6382: P_Approver_Id IN Per_People_F.Person_Id%TYPE,

6378: -- X_Error_Code - Varchar2
6379: /* ------------------------------------------------------------------------*/
6380:
6381: Procedure Validate_Overriding_Approver(
6382: P_Approver_Id IN Per_People_F.Person_Id%TYPE,
6383: X_Approver_Id OUT NOCOPY Per_People_F.Person_Id%TYPE,
6384: X_Error_Type OUT NOCOPY Varchar2,
6385: X_Error_Code OUT NOCOPY Varchar2) Is
6386:

Line 6383: X_Approver_Id OUT NOCOPY Per_People_F.Person_Id%TYPE,

6379: /* ------------------------------------------------------------------------*/
6380:
6381: Procedure Validate_Overriding_Approver(
6382: P_Approver_Id IN Per_People_F.Person_Id%TYPE,
6383: X_Approver_Id OUT NOCOPY Per_People_F.Person_Id%TYPE,
6384: X_Error_Type OUT NOCOPY Varchar2,
6385: X_Error_Code OUT NOCOPY Varchar2) Is
6386:
6387: Begin

Line 8756: Select max(effective_end_date) from per_people_f

8752: from hxc_recurring_periods hrp
8753: where hrp.recurring_period_id = p_rec_id;
8754: /* Added the cursor for bug 7584432 */
8755: Cursor get_termination_date(p_person_id number, p_stop_date DATE) is
8756: Select max(effective_end_date) from per_people_f
8757: where person_id = p_person_id and
8758: effective_end_date <= p_stop_date and
8759: (current_employee_flag = 'Y' or current_npw_flag = 'Y');
8760:

Line 10439: Per_People_F

10435: Decode(Current_Npw_Flag,'Y','CWK','EMP')
10436: Into
10437: X_Person_Type
10438: From
10439: Per_People_F
10440: Where
10441: P_Ei_Date between Effective_Start_Date
10442: and Effective_End_Date
10443: And Person_Id = P_Person_Id;