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 329: CURSOR cur_detail_exists(p_asg_id per_assignments_f.assignment_id%TYPE,

325: FROM ghr_pa_request_extra_info
326: WHERE pa_request_id = p_pa_request_rec.pa_request_id
327: AND information_type = 'GHR_US_PAR_DET_INFO';
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

Line 332: FROM per_assignment_status_types pst, per_assignments_f paf

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'

Line 444: from per_assignments_f

440: /***** Added Cursor BG_rec to get business group id given asg_id ****/
441:
442: Cursor Cur_bg(p_assignment_id NUMBER,p_eff_date DATE) is
443: Select business_group_id bg
444: from per_assignments_f
445: where assignment_id = p_assignment_id
446: and p_eff_date between effective_start_date
447: and effective_end_date;
448:

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

453: l_asg_ei_data per_assignment_extra_info%rowtype;
454: l_nte_date_flg BOOLEAN:=FALSE;
455:
456: --
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

Line 461: FROM per_assignment_status_types pst, per_assignments_f paf

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;

Line 2618: from per_assignments_f

2614: AND (elt.business_group_id is NULL or elt.business_group_id = p_bg_id);
2615: --
2616: Cursor Cur_bg(p_assignment_id NUMBER,p_eff_date DATE) is
2617: Select distinct business_group_id bg
2618: from per_assignments_f
2619: where assignment_id = p_assignment_id
2620: and p_eff_date between effective_start_date
2621: and effective_end_date;
2622: --