APPS.HR_CHANGE_START_DATE_API dependencies on PER_PERIODS_OF_SERVICE

Line 62: from per_periods_of_service pds

58: --
59: cursor csr_pds_exists is
60: select 'y' from dual where exists
61: (select 'x'
62: from per_periods_of_service pds
63: where pds.person_id = p_person_id
64: and pds.date_start = p_old_start_date);
65: --
66: cursor csr_pdp_exists is

Line 130: from per_periods_of_service pds

126: --
127: cursor csr_pds_exists is
128: select 'y' from dual where exists
129: (select 'x'
130: from per_periods_of_service pds
131: where pds.person_id = p_person_id
132: and pds.actual_termination_date < p_new_start_date
133: and pds.final_process_date >= p_new_start_date);
134: --

Line 147: FROM per_periods_of_service

143: -- 115.30 (START)
144: --
145: CURSOR csr_inv_new_hd IS
146: SELECT null
147: FROM per_periods_of_service
148: WHERE person_id = p_person_id
149: AND p_old_start_date BETWEEN NVL(last_standard_process_date,
150: actual_termination_date)+1
151: AND final_process_date

Line 156: FROM per_periods_of_service

152: AND p_new_start_date <= NVL(last_standard_process_date,actual_termination_date);
153: --
154: CURSOR csr_overlap (p_start_date DATE) IS
155: SELECT null
156: FROM per_periods_of_service
157: WHERE person_id = p_person_id
158: AND csr_overlap.p_start_date BETWEEN NVL(last_standard_process_date,
159: actual_termination_date)+1
160: AND NVL(final_process_date,hr_api.g_eot);

Line 167: FROM per_periods_of_service pds

163: l_new_start_date_in_range BOOLEAN;
164: --
165: CURSOR csr_new_start_date IS
166: SELECT null
167: FROM per_periods_of_service pds
168: WHERE pds.person_id = p_person_id
169: AND pds.date_start = p_old_start_date
170: AND p_new_start_date BETWEEN pds.actual_termination_date
171: AND pds.final_process_date;

Line 349: from per_periods_of_service

345: l_act_term_date DATE;
346: --
347: cursor pds is
348: select date_start,actual_termination_date
349: from per_periods_of_service
350: WHERE PERSON_ID = P_PERSON_ID
351: ORDER BY date_start;
352: --
353: cursor pdp is

Line 416: per_periods_of_service p

412: --
413: cursor assignment_pds is
414: select a.payroll_id , a.supervisor_id
415: from per_assignments_f a,
416: per_periods_of_service p
417: where a.period_of_service_id = p.period_of_service_id
418: and p.period_of_service_id = p_pds_or_pdp_id
419: and p_type= 'E'
420: and p.date_start = a.effective_start_date;

Line 491: per_periods_of_service p,

487: cursor csr_sp_placement_pds is
488: select 'x' from dual where exists
489: (select 1
490: from per_spinal_point_placements_f sp,
491: per_periods_of_service p,
492: per_assignments_f a
493: where a.person_id = p_person_id
494: and a.period_of_service_id = p.period_of_service_id
495: and p.period_of_service_id = p_pds_or_pdp_id

Line 638: per_periods_of_service p,

634: cursor csr_cost_pds is
635: select 'x' from dual where exists
636: (select 1
637: from PAY_COST_ALLOCATIONS_F ca,
638: per_periods_of_service p,
639: per_assignments_f a
640: where a.person_id = p_person_id
641: and a.period_of_service_id = p.period_of_service_id
642: and p.period_of_service_id = p_pds_or_pdp_id

Line 729: per_periods_of_service p,

725: cursor csr_budget_pds is
726: select 'x' from dual where exists
727: (select 1
728: from per_assignment_budget_values_f bud,
729: per_periods_of_service p,
730: per_assignments_f a
731: where a.person_id = p_person_id
732: and a.period_of_service_id = p.period_of_service_id
733: and p.period_of_service_id = p_pds_or_pdp_id

Line 1291: from per_periods_of_service pds

1287: ,p_old_start_date date
1288: ,p_new_start_date date
1289: ,p_type VARCHAR2) is
1290: cursor pds is select *
1291: from per_periods_of_service pds
1292: where person_id = p_person_id
1293: and date_start = p_old_start_date
1294: for update of date_start nowait;
1295: cursor pdp is select *

Line 2440: from per_periods_of_service

2436: --
2437: cursor csr_pds
2438: is
2439: select period_of_service_id
2440: from per_periods_of_service
2441: where person_id = p_person_id
2442: and date_start = p_old_start_date;
2443: --
2444: cursor csr_pdp