APPS.HR_CHANGE_START_DATE_API dependencies on PER_PERIODS_OF_SERVICE

Line 53: from per_periods_of_service pds

49: --
50: cursor csr_pds_exists is
51: select 'y' from dual where exists
52: (select 'x'
53: from per_periods_of_service pds
54: where pds.person_id = p_person_id
55: and pds.date_start = p_old_start_date);
56: --
57: cursor csr_pdp_exists is

Line 121: from per_periods_of_service pds

117: --
118: cursor csr_pds_exists is
119: select 'y' from dual where exists
120: (select 'x'
121: from per_periods_of_service pds
122: where pds.person_id = p_person_id
123: and pds.actual_termination_date < p_new_start_date
124: and pds.final_process_date >= p_new_start_date);
125: --

Line 138: FROM per_periods_of_service

134: -- 115.30 (START)
135: --
136: CURSOR csr_inv_new_hd IS
137: SELECT null
138: FROM per_periods_of_service
139: WHERE person_id = p_person_id
140: AND p_old_start_date BETWEEN NVL(last_standard_process_date,
141: actual_termination_date)+1
142: AND final_process_date

Line 147: FROM per_periods_of_service

143: AND p_new_start_date <= NVL(last_standard_process_date,actual_termination_date);
144: --
145: CURSOR csr_overlap (p_start_date DATE) IS
146: SELECT null
147: FROM per_periods_of_service
148: WHERE person_id = p_person_id
149: AND csr_overlap.p_start_date BETWEEN NVL(last_standard_process_date,
150: actual_termination_date)+1
151: AND NVL(final_process_date,hr_api.g_eot);

Line 158: FROM per_periods_of_service pds

154: l_new_start_date_in_range BOOLEAN;
155: --
156: CURSOR csr_new_start_date IS
157: SELECT null
158: FROM per_periods_of_service pds
159: WHERE pds.person_id = p_person_id
160: AND pds.date_start = p_old_start_date
161: AND p_new_start_date BETWEEN pds.actual_termination_date
162: AND pds.final_process_date;

Line 316: from per_periods_of_service

312: l_act_term_date DATE;
313: --
314: cursor pds is
315: select date_start,actual_termination_date
316: from per_periods_of_service
317: WHERE PERSON_ID = P_PERSON_ID
318: ORDER BY date_start;
319: --
320: cursor pdp is

Line 383: per_periods_of_service p

379: --
380: cursor assignment_pds is
381: select a.payroll_id , a.supervisor_id
382: from per_assignments_f a,
383: per_periods_of_service p
384: where a.period_of_service_id = p.period_of_service_id
385: and p.period_of_service_id = p_pds_or_pdp_id
386: and p_type= 'E'
387: and p.date_start = a.effective_start_date;

Line 458: per_periods_of_service p,

454: cursor csr_sp_placement_pds is
455: select 'x' from dual where exists
456: (select 1
457: from per_spinal_point_placements_f sp,
458: per_periods_of_service p,
459: per_assignments_f a
460: where a.person_id = p_person_id
461: and a.period_of_service_id = p.period_of_service_id
462: and p.period_of_service_id = p_pds_or_pdp_id

Line 566: per_periods_of_service p,

562: cursor csr_cost_pds is
563: select 'x' from dual where exists
564: (select 1
565: from PAY_COST_ALLOCATIONS_F ca,
566: per_periods_of_service p,
567: per_assignments_f a
568: where a.person_id = p_person_id
569: and a.period_of_service_id = p.period_of_service_id
570: and p.period_of_service_id = p_pds_or_pdp_id

Line 631: per_periods_of_service p,

627: cursor csr_budget_pds is
628: select 'x' from dual where exists
629: (select 1
630: from per_assignment_budget_values_f bud,
631: per_periods_of_service p,
632: per_assignments_f a
633: where a.person_id = p_person_id
634: and a.period_of_service_id = p.period_of_service_id
635: and p.period_of_service_id = p_pds_or_pdp_id

Line 943: from per_periods_of_service pds

939: ,p_old_start_date date
940: ,p_new_start_date date
941: ,p_type VARCHAR2) is
942: cursor pds is select *
943: from per_periods_of_service pds
944: where person_id = p_person_id
945: and date_start = p_old_start_date
946: for update of date_start nowait;
947: cursor pdp is select *

Line 2002: from per_periods_of_service

1998: --
1999: cursor csr_pds
2000: is
2001: select period_of_service_id
2002: from per_periods_of_service
2003: where person_id = p_person_id
2004: and date_start = p_old_start_date;
2005: --
2006: cursor csr_pdp