APPS.PER_PEOPLE_V7_PKG dependencies on PER_ASSIGNMENTS_F

Line 734: from per_assignments_f

730: --
731: cursor assignment
732: is
733: select effective_end_date
734: from per_assignments_f
735: where period_of_service_id = X_period_of_service_id
736: and effective_end_date = to_date('31-12-4712','DD-MM-YYYY')
737: for update of effective_end_date;
738: --

Line 867: update per_assignments_f

863: exit when assignment%notfound;
864: end loop;
865: close assignment;
866: begin
867: update per_assignments_f
868: set effective_end_date = X_termination_date
869: where period_of_service_id = X_period_of_service_id
870: and effective_end_date = to_date('31-12-4712','DD-MM-YYYY');
871: end;

Line 1047: from per_assignments_f

1043: for update of date_start;
1044: --
1045: cursor assignment is
1046: select effective_start_date
1047: from per_assignments_f
1048: where period_of_service_id = X_period_of_service_id
1049: and effective_start_date = X_s_hire_date
1050: and person_id = X_person_id
1051: for update of effective_start_date;

Line 1171: update per_assignments_f

1167: exit when assignment%notfound;
1168: end loop;
1169: close assignment;
1170: begin
1171: update per_assignments_f
1172: set effective_start_date = X_hire_date
1173: where period_of_service_id = X_period_of_service_id
1174: and effective_start_date = X_s_hire_date;
1175: -- VT 01/29/97 #417906 added exception

Line 1310: from per_assignments_f

1306: for update of Person_Id;
1307: --
1308: cursor assignment is
1309: select effective_start_date
1310: from per_assignments_f
1311: where period_of_service_id = X_period_of_service_id
1312: and effective_start_date = X_s_hire_date
1313: and person_id = X_person_id
1314: for update of effective_start_date;

Line 1466: update per_assignments_f

1462: exit when assignment%notfound;
1463: end loop;
1464: close assignment;
1465: --
1466: update per_assignments_f
1467: set effective_start_date = X_hire_date
1468: where period_of_service_id = X_period_of_service_id
1469: and effective_start_date = X_s_hire_date;
1470: --

Line 1613: from per_assignments_f

1609: --
1610: cursor assignment
1611: is
1612: select effective_end_date
1613: from per_assignments_f
1614: where person_id = X_person_id
1615: and effective_end_date = X_s_termination_date
1616: for update of effective_end_date;
1617: --

Line 1662: update per_assignments_f

1658: open assignment;
1659: loop
1660: fetch assignment into l_dummy_date;
1661: exit when assignment%NOTFOUND;
1662: update per_assignments_f
1663: set effective_end_date = hr_general.end_of_time
1664: where current of assignment;
1665: if SQL%ROWCOUNT <1 then
1666: raise NO_DATA_FOUND;

Line 2415: from per_assignments_f paf

2411: l_dummy VARCHAR2(1);
2412: cursor check_assignment_changes
2413: is
2414: select assignment_id
2415: from per_assignments_f paf
2416: , per_periods_of_service pos
2417: where paf.person_id = pos.person_id
2418: and paf.period_of_service_id = pos.period_of_service_id
2419: and pos.date_start = p_s_hire_date