APPS.GHR_SF52_PRE_UPDATE dependencies on PER_ALL_ASSIGNMENTS_F

Line 181: from per_all_assignments_f asg

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

Line 253: l_assignment_data per_all_assignments_f%rowtype;

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

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

842: from per_people_Extra_info pei
843: where pei.person_Extra_info_id = p_per_retained_grade.person_extra_info_id;
844:
845: -- Bug 3390876 Get User Status
846: CURSOR c_user_status(c_assignment_id per_all_assignments_f.assignment_id%type,
847: c_effective_date ghr_pa_requests.effective_date%type) IS
848: SELECT
849: ast.user_status,
850: ast.per_system_status,

Line 854: per_all_assignments_f asg

850: ast.per_system_status,
851: asg.effective_start_date
852: FROM
853: per_assignment_status_types ast,
854: per_all_assignments_f asg
855: WHERE
856: asg.assignment_id = c_assignment_id AND
857: ast.assignment_status_type_id = asg.assignment_status_type_id and
858: c_effective_date between asg.effective_start_date and asg.effective_end_date;

Line 2327: per_all_assignments_f asg

2323: ast.per_system_status,
2324: asg.effective_start_date
2325: from
2326: per_assignment_status_types ast,
2327: per_all_assignments_f asg
2328: where asg.assignment_id = p_pa_request_rec.employee_assignment_id
2329: and ast.assignment_status_type_id = asg.assignment_status_type_id
2330: and p_pa_request_rec.effective_date
2331: between asg.effective_start_date

Line 2337: per_all_assignments_f asg

2333:
2334: CURSOR c_user_apnt_status IS
2335: select ast.user_status,asg.effective_start_date
2336: from per_assignment_status_types ast,
2337: per_all_assignments_f asg
2338: where ast.assignment_status_type_id = asg.assignment_status_type_id
2339: and asg.assignment_id = p_pa_request_rec.employee_assignment_id
2340: and asg.primary_flag = 'Y'
2341: order by asg.effective_start_date;

Line 2349: per_all_assignments_f asg

2345: l_user_actv_apnt_status per_assignment_status_types.user_status%type;
2346: CURSOR c_user_actv_appt IS
2347: select ast.user_status
2348: from per_assignment_status_types ast,
2349: per_all_assignments_f asg
2350: where ast.assignment_status_type_id = asg.assignment_status_type_id
2351: and asg.assignment_id = p_pa_request_rec.employee_assignment_id
2352: and asg.primary_flag = 'Y'
2353: and user_status='Active Appointment';