APPS.PER_PERIODS_OF_SERVICE_PKG_V2 dependencies on PER_PEOPLE_F

Line 57: ( p_person_id IN per_people_f.person_id%TYPE

53: RETURN l_date;
54: END Get_Max_Last_Process_date;
55: -------------------------------------------------------------------------------
56: FUNCTION Get_Current_PDS_Record
57: ( p_person_id IN per_people_f.person_id%TYPE
58: )
59: RETURN per_periods_of_service%ROWTYPE
60: IS
61: l_record per_periods_of_service%ROWTYPE;

Line 64: ( p_person_id per_people_f.person_id%TYPE

60: IS
61: l_record per_periods_of_service%ROWTYPE;
62: --
63: CURSOR csr_pds_status
64: ( p_person_id per_people_f.person_id%TYPE
65: )
66: IS
67: SELECT *
68: FROM per_periods_of_service

Line 89: ( p_person_id IN per_people_f.person_id%TYPE

85: RETURN l_record;
86: END Get_Current_PDS_Record;
87: -------------------------------------------------------------------------------
88: FUNCTION Get_Current_Open_PDS_id
89: ( p_person_id IN per_people_f.person_id%TYPE
90: )
91: RETURN NUMBER
92: IS
93: l_record per_periods_of_service%ROWTYPE;

Line 106: ( p_person_id IN per_people_f.person_id%TYPE

102: END IF;
103: END Get_Current_Open_PDS_id;
104: -------------------------------------------------------------------------------
105: FUNCTION Is_Max_PDS_Not_Closed
106: ( p_person_id IN per_people_f.person_id%TYPE
107: )
108: RETURN BOOLEAN
109: IS
110: --

Line 147: FROM per_people_f ppf

143: ( p_person_id per_all_people_f.person_id%TYPE
144: , p_session_date DATE)
145: IS
146: SELECT date_of_birth, business_group_id
147: FROM per_people_f ppf
148: WHERE ppf.person_id = p_person_id
149: AND p_session_date between effective_start_date and effective_end_date;
150: --
151: BEGIN

Line 403: FROM per_people_f ppf, per_person_types ppt

399: ( p_person_id per_all_people_f.person_id%TYPE
400: , p_current_hire_date DATE)
401: IS
402: SELECT effective_start_date
403: FROM per_people_f ppf, per_person_types ppt
404: WHERE ppf.person_id = p_person_id
405: AND ppf.person_type_id = ppt.person_type_id
406: AND ppf.effective_start_date > p_current_hire_date;
407: BEGIN

Line 451: FROM per_people_f

447: --
448: CURSOR csr_per_row_count
449: IS
450: SELECT COUNT (*), person_type_id
451: FROM per_people_f
452: WHERE person_id = p_person_id
453: AND effective_start_date > p_final_process_date
454: GROUP BY person_type_id;
455: BEGIN

Line 944: ( p_person_id IN per_people_f.person_id%TYPE

940: RAISE;
941: END Get_Valid_Hire_Dates;
942: -------------------------------------------------------------------------------
943: FUNCTION IsBackToBackContract
944: ( p_person_id IN per_people_f.person_id%TYPE
945: , p_hire_date_of_current_pds IN DATE
946: )
947: RETURN BOOLEAN
948: IS