APPS.PQH_TENURE_DETAIL dependencies on PER_ALL_ASSIGNMENTS_F

Line 108: FROM per_all_assignments_f

104: FUNCTION getPersonSupervisor ( p_person_id IN NUMBER ) RETURN NUMBER IS
105:
106: CURSOR emp_super_cur IS
107: SELECT supervisor_id
108: FROM per_all_assignments_f
109: WHERE person_id = p_person_id
110: AND primary_flag = 'Y'
111: AND SYSDATE BETWEEN effective_start_date and effective_end_date;
112:

Line 143: FROM per_all_assignments_f paf

139: FUNCTION getPersonJobPosition ( p_person_id IN NUMBER ) RETURN VARCHAR2 IS
140:
141: CURSOR prim_asg IS
142: SELECT assignment_id,job_id,position_id
143: FROM per_all_assignments_f paf
144: WHERE paf.person_id = p_person_id
145: and sysdate between effective_start_date and effective_end_date
146: and primary_flag = 'Y'
147: and assignment_type = 'E';

Line 181: FROM per_all_assignments_f paf,

177:
178: /* Headcount of Tenure status till now for a supervisor */
179: CURSOR prsn_status_cnt_cur IS
180: SELECT COUNT(paf.person_id)
181: FROM per_all_assignments_f paf,
182: per_people_extra_info ppe
183: WHERE paf.person_id = ppe.person_id
184: and primary_flag ='Y' -- primary assignments only
185: and assignment_type ='E' -- only employees

Line 211: FROM per_all_assignments_f paf

207:
208: /* 4Faculty count of Tenure status till now for a supervisor */
209: CURSOR prsn_status_cnt_cur IS
210: SELECT count(person_id)
211: FROM per_all_assignments_f paf
212: WHERE assignment_type ='E'
213: and exists (
214: SELECT null
215: FROM per_people_extra_info ppe

Line 251: FROM per_all_assignments_f paf

247:
248: /* Faculty count of Tenure status till now for a supervisor */
249: CURSOR prsn_status_cnt_cur IS
250: SELECT count(person_id)
251: FROM per_all_assignments_f paf
252: WHERE assignment_type ='E'
253: and exists (
254: SELECT null
255: FROM per_people_extra_info ppe

Line 302: FROM per_all_assignments_f

298:
299: /* Total Faculty count irrespective of Tenure status */
300: CURSOR prsn_cnt_cur IS
301: SELECT COUNT(person_id)
302: FROM per_all_assignments_f
303: WHERE SYSDATE BETWEEN effective_start_date AND effective_end_date
304: and primary_flag ='Y'
305: -- 2005/08/08: NS: Performance fix: fetch the count for the business group
306: and business_group_id = hr_general.get_business_group_id

Line 312: FROM per_all_assignments_f paf,

308:
309: /* Faculty count of Tenured/Tenure-track status in final year of consideration*/
310: CURSOR prsn_tt_cnt_cur IS
311: SELECT COUNT(paf.person_id)
312: FROM per_all_assignments_f paf,
313: per_people_extra_info ppe
314: WHERE paf.person_id = ppe.person_id
315: AND ppe.information_type = 'PQH_TENURE_STATUS'
316: and primary_flag ='Y'

Line 327: FROM per_all_assignments_f paf,

323:
324: /* Faculty count of Tenure Status for current Year */
325: CURSOR prsn_ed_cnt_cur IS
326: SELECT COUNT(paf.person_id)
327: FROM per_all_assignments_f paf,
328: per_people_extra_info ppe
329: WHERE paf.person_id = ppe.person_id
330: and primary_flag ='Y'
331: and assignment_type ='E'

Line 341: FROM per_all_assignments_f paf,

337:
338: /* Faculty count of Tenure Status upto to start date */
339: CURSOR prsn_cnt_tillnow_cur IS
340: SELECT COUNT(paf.person_id)
341: FROM per_all_assignments_f paf,
342: per_people_extra_info ppe
343: WHERE paf.person_id = ppe.person_id
344: AND ppe.information_type = 'PQH_TENURE_STATUS'
345: and primary_flag ='Y'

Line 354: FROM per_all_assignments_f paf

350:
351: /*Faculty count of Tenured/Tenure-track status for current/upcoming/previous years */
352: CURSOR prsn_tt_sup_cnt_cur IS
353: SELECT count(person_id)
354: FROM per_all_assignments_f paf
355: WHERE assignment_type ='E'
356: and exists (
357: SELECT null
358: FROM per_people_extra_info ppe

Line 375: FROM per_all_assignments_f paf

371:
372: /* Faculty count of Tenure eligible/denied status for current year */
373: CURSOR prsn_ed_sup_cnt_cur IS
374: SELECT count(person_id)
375: FROM per_all_assignments_f paf
376: WHERE assignment_type ='E'
377: and exists (
378: SELECT null
379: FROM per_people_extra_info ppe

Line 395: FROM per_all_assignments_f paf

391:
392: /* Faculty count of Tenure status till now for a supervisor */
393: CURSOR prsn_sup_cnt_tillnow_cur IS
394: SELECT count(person_id)
395: FROM per_all_assignments_f paf
396: WHERE assignment_type ='E'
397: and exists (
398: SELECT null
399: FROM per_people_extra_info ppe