145: -------
146:
147: ------- Retrieve Person Sytem Status --
148: cursor c_asg_stat_type (p_asg_id number, p_eff_date date, p_status char) is
149: Select per_system_status from per_assignment_status_types pst, per_assignments_f paf
150: where paf.assignment_status_type_id = pst.assignment_status_type_id
151: and paf.assignment_type <> 'B'
152: and paf.assignment_id = p_asg_id
153: and pst.per_system_status = p_status
328:
329: CURSOR cur_detail_exists(p_asg_id per_assignments_f.assignment_id%TYPE,
330: p_eff_date ghr_pa_requests.effective_date%TYPE) IS
331: SELECT user_status
332: FROM per_assignment_status_types pst, per_assignments_f paf
333: WHERE paf.assignment_status_type_id = pst.assignment_status_type_id
334: AND paf.assignment_type <> 'B'
335: AND paf.assignment_id = p_asg_id
336: AND user_status ='Detail NTE'
457: CURSOR cur_nte_check(p_asg_id per_assignments_f.assignment_id%TYPE,
458: p_eff_date ghr_pa_requests.effective_date%TYPE)
459: IS
460: SELECT user_status
461: FROM per_assignment_status_types pst, per_assignments_f paf
462: WHERE paf.assignment_status_type_id = pst.assignment_status_type_id
463: AND paf.assignment_type <> 'B'
464: AND paf.assignment_id = p_asg_id
465: AND (p_eff_date) BETWEEN paf.effective_start_date AND paf.effective_end_date;
463: AND paf.assignment_type <> 'B'
464: AND paf.assignment_id = p_asg_id
465: AND (p_eff_date) BETWEEN paf.effective_start_date AND paf.effective_end_date;
466:
467: l_asg_status per_assignment_status_types.user_status%type;
468: --
469: --Begin Bug# 4748927
470: l_award_amount NUMBER;
471: --End Bug# 4748927