APPS.HR_CHANGE_START_DATE_API dependencies on PER_PERIODS_OF_PLACEMENT

Line 60: from per_periods_of_placement pdp

56: --
57: cursor csr_pdp_exists is
58: select 'y' from dual where exists
59: (select 'x'
60: from per_periods_of_placement pdp
61: where pdp.person_id = p_person_id
62: and pdp.date_start = p_old_start_date);
63: --
64: begin

Line 129: from per_periods_of_placement pdp

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

Line 322: from per_periods_of_placement

318: ORDER BY date_start;
319: --
320: cursor pdp is
321: select date_start,actual_termination_date
322: from per_periods_of_placement
323: WHERE PERSON_ID = P_PERSON_ID
324: ORDER BY date_start;
325: --
326: begin

Line 392: per_periods_of_placement p

388: --
389: cursor assignment_pdp is
390: select a.payroll_id , a.supervisor_id
391: from per_assignments_f a,
392: per_periods_of_placement p
393: where a.period_of_placement_date_start = p.date_start
394: and a.person_id = p.person_id
395: and p.period_of_placement_id = p_pds_or_pdp_id
396: and p_type= 'C'

Line 473: per_periods_of_placement p,

469: cursor csr_sp_placement_pdp is
470: select 'x' from dual where exists
471: (select 1
472: from per_spinal_point_placements_f sp,
473: per_periods_of_placement p,
474: per_assignments_f a
475: where a.person_id = p_person_id
476: and a.period_of_placement_date_start = p.date_start
477: and p.period_of_placement_id = p_pds_or_pdp_id

Line 524: per_periods_of_placement p,

520: cursor csr_asg_rates_pdp is
521: select 'x' from dual where exists
522: (select 1
523: from pay_grade_rules_f pgr,
524: per_periods_of_placement p,
525: per_assignments_f a
526: where a.person_id = p_person_id
527: and a.period_of_placement_date_start = p.date_start
528: and p.period_of_placement_id = p_pds_or_pdp_id

Line 580: per_periods_of_placement p,

576: cursor csr_cost_pdp is
577: select 'x' from dual where exists
578: (select 1
579: from PAY_COST_ALLOCATIONS_F ca,
580: per_periods_of_placement p,
581: per_assignments_f a
582: where a.person_id = p_person_id
583: and a.period_of_placement_date_start = p.date_start
584: and p.period_of_placement_id = p_pds_or_pdp_id

Line 645: per_periods_of_placement p,

641: cursor csr_budget_pdp is
642: select 'x' from dual where exists
643: (select 1
644: from per_assignment_budget_values_f bud,
645: per_periods_of_placement p,
646: per_assignments_f a
647: where a.person_id = p_person_id
648: and a.period_of_placement_date_start = p.date_start
649: and p.period_of_placement_id = p_pds_or_pdp_id

Line 948: from per_periods_of_placement pdp

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 *
948: from per_periods_of_placement pdp
949: where person_id = p_person_id
950: and date_start = p_old_start_date
951: for update of date_start nowait;
952: --

Line 995: update per_periods_of_placement

991: hr_utility.raise_error;
992: else
993: close pdp;
994: end if;
995: update per_periods_of_placement
996: set date_start = p_new_start_date
997: where period_of_placement_id = pdp_rec.period_of_placement_id
998: and date_start = p_old_start_date
999: and person_id = p_person_id;

Line 2009: from per_periods_of_placement

2005: --
2006: cursor csr_pdp
2007: is
2008: select period_of_placement_id
2009: from per_periods_of_placement
2010: where person_id = p_person_id
2011: and date_start = p_old_start_date;
2012: --
2013: -- 115.30,115.33 (START)

Line 2036: l_pds_or_pdp_id per_periods_of_placement.period_of_placement_id%TYPE;

2032: --
2033: -- 115.30,115.33 (END)
2034: --
2035: l_proc varchar2(30):='update_start_date';
2036: l_pds_or_pdp_id per_periods_of_placement.period_of_placement_id%TYPE;
2037: l_old_start_date DATE;
2038: l_new_start_date DATE;
2039: l_earlier_date DATE;
2040: l_later_date DATE;