APPS.HR_ENTRY dependencies on PER_PERIODS_OF_SERVICE

Line 32: from per_periods_of_service pos,

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

Line 362: from per_periods_of_service p,

358: 'D', p.date_start + l_qualifying_los,
359: 'Y', add_months(p.date_start,(12 * l_qualifying_los)),
360: 'W', p.date_start + (l_qualifying_los * 7),
361: add_months(p.date_start,l_qualifying_los))
362: from per_periods_of_service p,
363: per_all_assignments_f a
364: where a.assignment_id = p_assignment_id
365: and p.period_of_service_id = a.period_of_service_id;
366: --

Line 939: l_service_rec per_periods_of_service%rowtype;

935: and p_session_date is not null
936: );
937: --
938: l_post_termination_rule varchar2(10);
939: l_service_rec per_periods_of_service%rowtype;
940: l_eff_term_date date;
941: --
942: begin
943: --

Line 1175: from per_periods_of_service ser

1171: begin
1172: -- Get termination dates for employee
1173: select ser.*
1174: into l_service_rec
1175: from per_periods_of_service ser
1176: where ser.person_id = (select distinct person_id
1177: from per_all_assignments_f
1178: where assignment_id = p_assignment_id)
1179: and (c1rec.effective_start_date - 1) between ser.date_start

Line 1459: per_periods_of_service pos

1455: v_actual_termination_date,
1456: v_last_standard_process_date,
1457: v_final_process_date
1458: from per_assignments_f asg,
1459: per_periods_of_service pos
1460: where asg.assignment_id = p_assignment_id
1461: and asg.period_of_service_id = pos.period_of_service_id (+)
1462: and p_session_date between asg.effective_start_date
1463: and asg.effective_end_date;

Line 3338: from per_periods_of_service pos,

3334: and p_session_date between pel.effective_start_date and pel.effective_end_date;
3335:
3336: select min(pos.actual_termination_date)
3337: into v_actual_termination_date
3338: from per_periods_of_service pos,
3339: per_assignments_f pa
3340: where pos.person_id = pa.person_id
3341: and pa.assignment_id = p_assignment_id
3342: and p_session_date