[Home] [Help]
792: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
793: l_position_id per_positions.position_id%type;
794: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
795: l_session ghr_history_api.g_session_var_type;
796: l_person_status per_assignment_status_types.user_status%type;
797:
798: -- Bug 3021003
799: l_ret_flag BOOLEAN := FALSE;
800: -- Cursor to retrieve the Person Type of the Person , as of the effective_date of the Request
829: ast.user_status,
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
2189: -- End Bug 3260890
2190:
2191: -- Bug# 4672772 Begin
2192:
2193: l_old_user_status per_assignment_status_types.user_status%type;
2194: l_old_system_status per_assignment_status_types.per_system_status%type;
2195: l_old_effective_start_date date;
2196: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
2197: l_user_apnt_status per_assignment_status_types.user_status%type;
2190:
2191: -- Bug# 4672772 Begin
2192:
2193: l_old_user_status per_assignment_status_types.user_status%type;
2194: l_old_system_status per_assignment_status_types.per_system_status%type;
2195: l_old_effective_start_date date;
2196: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
2197: l_user_apnt_status per_assignment_status_types.user_status%type;
2198: l_user_apnt_eff_date date;
2193: l_old_user_status per_assignment_status_types.user_status%type;
2194: l_old_system_status per_assignment_status_types.per_system_status%type;
2195: l_old_effective_start_date date;
2196: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
2197: l_user_apnt_status per_assignment_status_types.user_status%type;
2198: l_user_apnt_eff_date date;
2199:
2200: Cursor c_user_status is
2201: select ast.user_status,
2201: select ast.user_status,
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
2211: and asg.effective_end_date;
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;
2221:
2222: -- Bug# 4672772 End
2223: --Begin Bug# 6083404
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
2223: --Begin Bug# 6083404
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'