APPS.GHR_SF52_PRE_UPDATE dependencies on PER_ALL_ASSIGNMENTS_F

Line 178: from per_all_assignments_f asg

174: and ppf.effective_end_date;
175:
176: cursor cur_asg_prior_date is
177: Select asg.effective_start_date
178: from per_all_assignments_f asg
179: Where asg.assignment_id = p_pa_request_rec.employee_assignment_id
180: order by 1 desc;
181:
182: l_imm_asg_sf52 ghr_api.asg_sf52_type;

Line 249: l_assignment_data per_all_assignments_f%rowtype;

245: l_special_info_type ghr_api.special_information_type;
246: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
247: l_session ghr_history_api.g_session_var_type;
248: l_asg_ei_data per_assignment_extra_info%rowtype;
249: l_assignment_data per_all_assignments_f%rowtype;
250: l_result_code varchar2(50);
251: l_person_type per_person_types.system_person_type%type;
252: l_effective_date date;
253: -- Bug#4054110

Line 826: CURSOR c_user_status(c_assignment_id per_all_assignments_f.assignment_id%type,

822: from per_people_Extra_info pei
823: where pei.person_Extra_info_id = p_per_retained_grade.person_extra_info_id;
824:
825: -- Bug 3390876 Get User Status
826: CURSOR c_user_status(c_assignment_id per_all_assignments_f.assignment_id%type,
827: c_effective_date ghr_pa_requests.effective_date%type) IS
828: SELECT
829: ast.user_status,
830: ast.per_system_status,

Line 834: per_all_assignments_f asg

830: ast.per_system_status,
831: asg.effective_start_date
832: FROM
833: per_assignment_status_types ast,
834: per_all_assignments_f asg
835: WHERE
836: asg.assignment_id = c_assignment_id AND
837: ast.assignment_status_type_id = asg.assignment_status_type_id and
838: c_effective_date between asg.effective_start_date and asg.effective_end_date;

Line 2206: per_all_assignments_f asg

2202: ast.per_system_status,
2203: asg.effective_start_date
2204: from
2205: per_assignment_status_types ast,
2206: per_all_assignments_f asg
2207: where asg.assignment_id = p_pa_request_rec.employee_assignment_id
2208: and ast.assignment_status_type_id = asg.assignment_status_type_id
2209: and p_pa_request_rec.effective_date
2210: between asg.effective_start_date

Line 2216: per_all_assignments_f asg

2212:
2213: CURSOR c_user_apnt_status IS
2214: select ast.user_status,asg.effective_start_date
2215: from per_assignment_status_types ast,
2216: per_all_assignments_f asg
2217: where ast.assignment_status_type_id = asg.assignment_status_type_id
2218: and asg.assignment_id = p_pa_request_rec.employee_assignment_id
2219: and asg.primary_flag = 'Y'
2220: order by asg.effective_start_date;

Line 2228: per_all_assignments_f asg

2224: l_user_actv_apnt_status per_assignment_status_types.user_status%type;
2225: CURSOR c_user_actv_appt IS
2226: select ast.user_status
2227: from per_assignment_status_types ast,
2228: per_all_assignments_f asg
2229: where ast.assignment_status_type_id = asg.assignment_status_type_id
2230: and asg.assignment_id = p_pa_request_rec.employee_assignment_id
2231: and asg.primary_flag = 'Y'
2232: and user_status='Active Appointment';