APPS.GHR_DS_JAN99_PKG dependencies on PER_ASSIGNMENTS_F

Line 18: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

14: l_old_locality_pay_area_id ghr_duty_stations_f.locality_pay_area_id%TYPE;
15: l_new_locality_pay_area_id ghr_duty_stations_f.locality_pay_area_id%TYPE;
16: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;
17: l_person_id per_people_f.person_id%TYPE;
18: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
19: l_full_name per_people_f.full_name%TYPE;
20: l_national_identifier per_people_f.national_identifier%TYPE;
21: l_assignment_id per_assignments_f.assignment_id%TYPE;
22: l_location_id per_assignments_f.location_id%TYPE;

Line 21: l_assignment_id per_assignments_f.assignment_id%TYPE;

17: l_person_id per_people_f.person_id%TYPE;
18: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
19: l_full_name per_people_f.full_name%TYPE;
20: l_national_identifier per_people_f.national_identifier%TYPE;
21: l_assignment_id per_assignments_f.assignment_id%TYPE;
22: l_location_id per_assignments_f.location_id%TYPE;
23: l_position_id per_assignments_f.position_id%TYPE;
24: l_pos_name per_positions.name%TYPE;
25: l_organization_id per_assignments_f.organization_id%TYPE;

Line 22: l_location_id per_assignments_f.location_id%TYPE;

18: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
19: l_full_name per_people_f.full_name%TYPE;
20: l_national_identifier per_people_f.national_identifier%TYPE;
21: l_assignment_id per_assignments_f.assignment_id%TYPE;
22: l_location_id per_assignments_f.location_id%TYPE;
23: l_position_id per_assignments_f.position_id%TYPE;
24: l_pos_name per_positions.name%TYPE;
25: l_organization_id per_assignments_f.organization_id%TYPE;
26: l_effective_date date;

Line 23: l_position_id per_assignments_f.position_id%TYPE;

19: l_full_name per_people_f.full_name%TYPE;
20: l_national_identifier per_people_f.national_identifier%TYPE;
21: l_assignment_id per_assignments_f.assignment_id%TYPE;
22: l_location_id per_assignments_f.location_id%TYPE;
23: l_position_id per_assignments_f.position_id%TYPE;
24: l_pos_name per_positions.name%TYPE;
25: l_organization_id per_assignments_f.organization_id%TYPE;
26: l_effective_date date;
27: l_assign_effective_date date;

Line 25: l_organization_id per_assignments_f.organization_id%TYPE;

21: l_assignment_id per_assignments_f.assignment_id%TYPE;
22: l_location_id per_assignments_f.location_id%TYPE;
23: l_position_id per_assignments_f.position_id%TYPE;
24: l_pos_name per_positions.name%TYPE;
25: l_organization_id per_assignments_f.organization_id%TYPE;
26: l_effective_date date;
27: l_assign_effective_date date;
28:
29:

Line 124: from per_assignments_f paf,

120: select paf.person_id person_id,
121: paf.effective_start_date effective_start_date,
122: paf.assignment_id assignment_id,
123: paf.object_version_number object_version_number
124: from per_assignments_f paf,
125: per_assignment_status_types ast
126: where l_effective_date between paf.effective_start_date
127: and paf.effective_end_date
128: and paf.location_id = p_old_location_id

Line 136: from per_assignments_f paf1,

132: select paf1.person_id person_id,
133: paf1.effective_start_date effective_start_date,
134: paf1.assignment_id assignment_id,
135: paf1.object_version_number object_version_number
136: from per_assignments_f paf1,
137: per_assignment_status_types ast1
138: where l_effective_date <= paf1.effective_start_date
139: and paf1.location_id = p_old_location_id
140: and ast1.assignment_status_type_id = paf1.assignment_status_type_id

Line 155: from per_assignments_f asg

151:
152: cursor c_update_mode_a is
153: select asg.effective_start_date ,
154: asg.effective_end_date
155: from per_assignments_f asg
156: where asg.assignment_id = l_assignment_id
157: and l_assign_effective_date
158: between asg.effective_start_date
159: and asg.effective_end_date;

Line 164: from per_assignments_f asg

160:
161: cursor c_update_mode_a1 is
162: select asg.effective_start_date ,
163: asg.effective_end_date
164: from per_assignments_f asg
165: where asg.assignment_id = l_assignment_id
166: and l_assign_effective_date < asg.effective_start_date;
167:
168: cursor cur_position is