APPS.PER_PERRPRAS_XMLP_PKG dependencies on PER_ASSIGNMENTS_F

Line 218: from per_assignments_f

214: begin
215: begin
216: select max(effective_end_date) + 1
217: into l_status_start_date
218: from per_assignments_f
219: where assignment_id = p_assignment_id
220: and assignment_status_type_id <> p_assignment_status_type_id
221: and effective_end_date < C_SESSION_DATE;
222: exception

Line 229: from per_assignments_f

225: if l_status_start_date is null then
226: begin
227: select min(effective_start_date)
228: into l_status_start_date
229: from per_assignments_f
230: where assignment_id = p_assignment_id
231: and assignment_status_type_id = p_assignment_status_type_id
232: and effective_start_date <= C_SESSION_DATE;
233: exception

Line 249: from per_assignments_f

245: begin
246: begin
247: select min(effective_start_date) - 1
248: into l_status_end_date
249: from per_assignments_f
250: where assignment_id = p_assignment_id
251: and assignment_status_type_id <> p_assignment_status_type_id
252: and effective_start_date > C_SESSION_DATE;
253: exception

Line 260: from per_assignments_f

256: if l_status_end_date is null then
257: begin
258: select max(effective_end_date)
259: into l_status_end_date
260: from per_assignments_f
261: where assignment_id = p_assignment_id
262: and assignment_status_type_id = p_assignment_status_type_id
263: and effective_end_date >= C_SESSION_DATE;
264: exception