[Home] [Help]
812: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
813: l_position_id per_positions.position_id%type;
814: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
815: l_session ghr_history_api.g_session_var_type;
816: l_person_status per_assignment_status_types.user_status%type;
817:
818: -- Bug 3021003
819: l_ret_flag BOOLEAN := FALSE;
820: -- Cursor to retrieve the Person Type of the Person , as of the effective_date of the Request
849: ast.user_status,
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
2310: -- End Bug 3260890
2311:
2312: -- Bug# 4672772 Begin
2313:
2314: l_old_user_status per_assignment_status_types.user_status%type;
2315: l_old_system_status per_assignment_status_types.per_system_status%type;
2316: l_old_effective_start_date date;
2317: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
2318: l_user_apnt_status per_assignment_status_types.user_status%type;
2311:
2312: -- Bug# 4672772 Begin
2313:
2314: l_old_user_status per_assignment_status_types.user_status%type;
2315: l_old_system_status per_assignment_status_types.per_system_status%type;
2316: l_old_effective_start_date date;
2317: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
2318: l_user_apnt_status per_assignment_status_types.user_status%type;
2319: l_user_apnt_eff_date date;
2314: l_old_user_status per_assignment_status_types.user_status%type;
2315: l_old_system_status per_assignment_status_types.per_system_status%type;
2316: l_old_effective_start_date date;
2317: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
2318: l_user_apnt_status per_assignment_status_types.user_status%type;
2319: l_user_apnt_eff_date date;
2320:
2321: Cursor c_user_status is
2322: select ast.user_status,
2322: select ast.user_status,
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
2332: and asg.effective_end_date;
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;
2342:
2343: -- Bug# 4672772 End
2344: --Begin Bug# 6083404
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
2344: --Begin Bug# 6083404
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'