APPS.HR_CANCEL_HIRE_API dependencies on PER_PERIODS_OF_SERVICE

Line 77: FROM per_periods_of_service pos

73: SELECT DISTINCT
74: paa.business_group_id
75: ,pos.period_of_service_id
76: ,pos.date_start
77: FROM per_periods_of_service pos
78: ,per_all_assignments_f paa
79: WHERE paa.person_id = p_person_id
80: AND p_effective_date BETWEEN
81: paa.effective_start_date AND paa.effective_end_date

Line 88: FROM per_periods_of_service pos2

84: -- 115.3 (START)
85: --
86: AND pos.date_start IN
87: (SELECT MAX(pos2.date_start)
88: FROM per_periods_of_service pos2
89: WHERE pos2.person_id = p_person_id)
90: --
91: -- 115.3 (END)
92: --

Line 101: FROM per_periods_of_service pos

97: SELECT DISTINCT
98: paa.business_group_id
99: ,pos.period_of_service_id
100: ,pos.date_start
101: FROM per_periods_of_service pos
102: ,per_all_assignments_f paa
103: WHERE paa.person_id = p_person_id
104: AND p_effective_date BETWEEN
105: paa.effective_start_date AND paa.effective_end_date

Line 245: per_periods_of_service

241: (p_effective_date IN DATE
242: ,p_person_id IN NUMBER
243: ) is
244: select 'X' from
245: per_periods_of_service
246: where person_id = p_person_id
247: and actual_termination_date = p_effective_date;
248:
249: p_ser_dummy varchar2(10);