APPS.GHR_VALIDATE_CHECK dependencies on PER_ASSIGNMENTS_F

Line 127: from per_assignments_f asg1

123:
124: -------
125: cursor c_asg_posn_check(p_To_Position_id number, p_person_id number, p_eff_date date) is
126: select asg1.assignment_id
127: from per_assignments_f asg1
128: where
129: asg1.person_id <> p_person_id
130: and asg1.position_id = p_to_position_id
131: and asg1.assignment_type NOT IN ('B','A')

Line 138: from per_assignments_f asg1

134: between asg1.effective_start_date and asg1.effective_end_date);
135:
136: cursor c_asg_posn_check1(p_To_Position_id number, p_person_id number, p_eff_date date) is
137: select asg1.assignment_id
138: from per_assignments_f asg1
139: where asg1.person_id <> p_person_id
140: and asg1.position_id = p_to_position_id
141: and asg1.assignment_type NOT IN ('B','A')
142: and (p_eff_date

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 388: from per_assignments_f

384: /***** Added Cursor BG_rec to get business group id given asg_id ****/
385:
386: Cursor Cur_bg(p_assignment_id NUMBER,p_eff_date DATE) is
387: Select business_group_id bg
388: from per_assignments_f
389: where assignment_id = p_assignment_id
390: and p_eff_date between effective_start_date
391: and effective_end_date;
392:

Line 401: CURSOR cur_nte_check(p_asg_id per_assignments_f.assignment_id%TYPE,

397: l_asg_ei_data per_assignment_extra_info%rowtype;
398: l_nte_date_flg BOOLEAN:=FALSE;
399:
400: --
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

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 2318: from per_assignments_f

2314: AND (elt.business_group_id is NULL or elt.business_group_id = p_bg_id);
2315: --
2316: Cursor Cur_bg(p_assignment_id NUMBER,p_eff_date DATE) is
2317: Select distinct business_group_id bg
2318: from per_assignments_f
2319: where assignment_id = p_assignment_id
2320: and p_eff_date between effective_start_date
2321: and effective_end_date;
2322: --