APPS.HR_DATE_CHK dependencies on PER_PERIODS_OF_SERVICE

Line 282: from per_periods_of_service

278: cursor pps
279: is
280: select date_start
281: ,actual_termination_date
282: from per_periods_of_service
283: WHERE PERSON_ID = P_PERSON_ID
284: ORDER BY date_start;
285: --
286: begin

Line 322: per_periods_of_service p

318: --
319: cursor assignment is
320: select a.payroll_id , a.supervisor_id
321: from per_assignments_f a,
322: per_periods_of_service p
323: where a.period_of_service_id = p.period_of_service_id
324: and p.period_of_service_id = p_period_of_service_id
325: and p.date_start = a.effective_start_date;
326: --

Line 381: per_periods_of_service p,

377: into v_dummy
378: from sys.dual
379: where exists (select null
380: from pay_element_entries_f n,
381: per_periods_of_service p,
382: per_assignments_f a
383: where a.person_id = p_person_id
384: and a.period_of_service_id = p_period_of_service_id
385: and p.period_of_service_id = p_period_of_service_id

Line 410: per_periods_of_service p,

406: into v_dummy
407: from sys.dual
408: where exists (select 1
409: from per_spinal_point_placements_f sp,
410: per_periods_of_service p,
411: per_assignments_f a
412: where a.person_id = p_person_id
413: and a.period_of_service_id = p_period_of_service_id
414: and p.period_of_service_id = p_period_of_service_id

Line 442: per_periods_of_service p,

438: into v_dummy
439: from sys.dual
440: where exists (select 1
441: from PAY_COST_ALLOCATIONS_F ca,
442: per_periods_of_service p,
443: per_assignments_f a
444: where a.person_id = p_person_id
445: and a.period_of_service_id = p_period_of_service_id
446: and p.period_of_service_id = p_period_of_service_id

Line 748: from per_periods_OF_SERVICE

744: --
745: cursor pps
746: is
747: select period_of_Service_id
748: from per_periods_OF_SERVICE
749: WHERE PERSON_ID = P_PERSON_ID
750: AND DATE_START = P_S_START_DATE;
751: --
752: cursor csr_get_bg is