APPS.HR_ENTRY dependencies on PER_PERIODS_OF_SERVICE

Line 29: from per_periods_of_service pos,

25: end if;
26: begin
27: select pos.actual_termination_date
28: into l_actual_termination_date
29: from per_periods_of_service pos,
30: per_assignments_f pa
31: where pos.person_id = pa.person_id
32: and pa.assignment_id = p_assignment_id
33: and p_session_date

Line 331: from per_periods_of_service p,

327: 'D', p.date_start + l_qualifying_los,
328: 'Y', add_months(p.date_start,(12 * l_qualifying_los)),
329: 'W', p.date_start + (l_qualifying_los * 7),
330: add_months(p.date_start,l_qualifying_los))
331: from per_periods_of_service p,
332: per_all_assignments_f a
333: where a.assignment_id = p_assignment_id
334: and p.period_of_service_id = a.period_of_service_id;
335: --

Line 1267: per_periods_of_service pos

1263: v_actual_termination_date,
1264: v_last_standard_process_date,
1265: v_final_process_date
1266: from per_assignments_f asg,
1267: per_periods_of_service pos
1268: where asg.assignment_id = p_assignment_id
1269: and asg.period_of_service_id = pos.period_of_service_id (+)
1270: and p_session_date between asg.effective_start_date
1271: and asg.effective_end_date;