APPS.PER_PEOPLE_V15_PKG dependencies on PER_ASSIGNMENTS_F

Line 321: from per_assignments_f

317: --
318: cursor assignment
319: is
320: select effective_end_date
321: from per_assignments_f
322: where period_of_service_id = X_period_of_service_id
323: and effective_end_date = to_date('31-12-4712','DD-MM-YYYY')
324: for update of effective_end_date;
325: --

Line 372: update per_assignments_f

368: exit when assignment%notfound;
369: end loop;
370: close assignment;
371: begin
372: update per_assignments_f
373: set effective_end_date = X_termination_date
374: where period_of_service_id = X_period_of_service_id
375: and effective_end_date = to_date('31-12-4712','DD-MM-YYYY');
376: end;

Line 511: from per_assignments_f

507: for update of date_start;
508: --
509: cursor assignment is
510: select effective_start_date
511: from per_assignments_f
512: where period_of_service_id = X_period_of_service_id
513: and effective_start_date = X_s_hire_date
514: and person_id = X_person_id
515: for Update of effective_start_date;

Line 546: update per_assignments_f

542: exit when assignment%notfound;
543: end loop;
544: close assignment;
545: begin
546: update per_assignments_f
547: set effective_start_date = X_hire_date
548: where period_of_service_id = X_period_of_service_id
549: and effective_start_date = X_s_hire_date;
550: -- VT 01/29/97 #417906 added exception

Line 591: from per_assignments_f

587: --
588: cursor assignment
589: is
590: select effective_end_date
591: from per_assignments_f
592: where person_id = X_person_id
593: and effective_end_date = X_s_termination_date
594: for update of effective_end_date;
595: --

Line 612: update per_assignments_f

608: open assignment;
609: loop
610: fetch assignment into l_dummy_date;
611: exit when assignment%NOTFOUND;
612: update per_assignments_f
613: set effective_end_date = to_date('31-12-4712','DD-MM-YYYY')
614: where current of assignment;
615: if SQL%ROWCOUNT <1 then
616: raise NO_DATA_FOUND;

Line 970: from per_assignments_f paf

966: l_dummy VARCHAR2(1);
967: cursor check_assignment_changes
968: is
969: select assignment_id
970: from per_assignments_f paf
971: , per_periods_of_service pos
972: where paf.person_id = pos.person_id
973: and paf.period_of_service_id = pos.period_of_service_id
974: and pos.date_start = p_s_hire_date