APPS.HR_FR_MMO dependencies on PER_ALL_ASSIGNMENTS_F

Line 84: from per_all_assignments_f a,

80: Assignment Status Type and Establishment criteria
81: */
82: select max(a.effective_end_date) + 1
83: into l_date
84: from per_all_assignments_f a,
85: per_assignment_status_types s
86: where a.person_id = p_person_id
87: AND a.primary_flag = 'Y'
88: AND a.effective_end_date < p_end_date

Line 102: from per_all_assignments_f a,

98: */
99:
100: select max(a.effective_start_date)
101: into l_date
102: from per_all_assignments_f a,
103: per_assignment_status_types s
104: where a.person_id = p_person_id
105: AND a.primary_flag = 'Y'
106: AND a.effective_start_date < p_end_date

Line 113: from per_all_assignments_f a2,

109: ('ACTIVE_ASSIGN',decode(p_include_suspended,'Y','SUSP_ASSIGN','ACTIVE_ASSIGN'))
110: AND a.establishment_id = p_establishment_id)
111: and not exists
112: (select null
113: from per_all_assignments_f a2,
114: per_assignment_status_types s2
115: where a2.person_id = p_person_id
116: AND a2.primary_flag = 'Y'
117: AND a2.effective_end_date = a.effective_start_date-1

Line 152: from per_all_assignments_f a,

148: Assignment Status Type and Establishment criteria
149: */
150: select min(a.effective_start_date) - 1
151: into l_date
152: from per_all_assignments_f a,
153: per_assignment_status_types s
154: where a.person_id = p_person_id
155: AND a.primary_flag = 'Y'
156: AND a.effective_start_date > p_start_date

Line 170: from per_all_assignments_f a,

166: for which there is no succeeding record which meets the criteria
167: */
168: select min(a.effective_end_date)
169: into l_date
170: from per_all_assignments_f a,
171: per_assignment_status_types s
172: where a.person_id = p_person_id
173: AND a.primary_flag = 'Y'
174: AND a.effective_end_date > p_start_date

Line 182: from per_all_assignments_f a2,

178: ('ACTIVE_ASSIGN',decode(p_include_suspended,'Y','SUSP_ASSIGN','ACTIVE_ASSIGN'))
179: AND a.establishment_id = p_establishment_id)
180: and not exists
181: (select null
182: from per_all_assignments_f a2,
183: per_assignment_status_types s2
184: where a2.person_id = p_person_id
185: AND a2.primary_flag = 'Y'
186: AND a2.effective_start_date = a.effective_end_date+1