APPS.GHR_VALIDATE_CHECK dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 149: Select per_system_status from per_assignment_status_types pst, per_assignments_f paf

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

Line 405: FROM per_assignment_status_types pst, per_assignments_f paf

401: CURSOR cur_nte_check(p_asg_id per_assignments_f.assignment_id%TYPE,
402: p_eff_date ghr_pa_requests.effective_date%TYPE)
403: IS
404: SELECT user_status
405: FROM per_assignment_status_types pst, per_assignments_f paf
406: WHERE paf.assignment_status_type_id = pst.assignment_status_type_id
407: AND paf.assignment_type <> 'B'
408: AND paf.assignment_id = p_asg_id
409: AND (p_eff_date) BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line 411: l_asg_status per_assignment_status_types.user_status%type;

407: AND paf.assignment_type <> 'B'
408: AND paf.assignment_id = p_asg_id
409: AND (p_eff_date) BETWEEN paf.effective_start_date AND paf.effective_end_date;
410:
411: l_asg_status per_assignment_status_types.user_status%type;
412: --
413: --Begin Bug# 4748927
414: l_award_amount NUMBER;
415: --End Bug# 4748927