APPS.PQH_TENURE_DETAIL dependencies on PER_PEOPLE_EXTRA_INFO

Line 49: FROM per_people_extra_info

45: CURSOR emp_tenure_cur IS
46: SELECT pei_information1 tenure_status,
47: FND_DATE.canonical_to_date(PEI_INFORMATION2) date_determined,
48: FND_DATE.canonical_to_date(nvl(PEI_INFORMATION4,PEI_INFORMATION3)) adjusted_tenure_date
49: FROM per_people_extra_info
50: WHERE person_id = p_person_id
51: AND information_type = 'PQH_TENURE_STATUS' ;
52:
53: /* Join with HR_LOOKUPS to get the Tenure Status Description. */

Line 126: FROM per_people_extra_info

122: FUNCTION getPersonRank (p_person_id IN NUMBER ) RETURN VARCHAR2 IS
123:
124: CURSOR emp_rank_cur IS
125: SELECT hr_general.decode_lookup('PQH_ACADEMIC_RANK',pei_information1)
126: FROM per_people_extra_info
127: WHERE person_id = p_person_id
128: AND information_type = 'PQH_ACADEMIC_RANK' ;
129:
130: l_academic_rank hr_lookups.meaning%type;

Line 182: per_people_extra_info ppe

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
186: AND ppe.information_type = 'PQH_TENURE_STATUS'

Line 215: FROM per_people_extra_info ppe

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
216: WHERE ppe.information_type = 'PQH_TENURE_STATUS'
217: AND ppe.pei_information1 = p_tenure_status
218: AND paf.person_id = ppe.person_id
219: AND FND_DATE.canonical_to_date(PPE.PEI_INFORMATION2) BETWEEN p_start_date AND p_end_date)

Line 222: FROM per_people_extra_info eiar

218: AND paf.person_id = ppe.person_id
219: AND FND_DATE.canonical_to_date(PPE.PEI_INFORMATION2) BETWEEN p_start_date AND p_end_date)
220: and exists (
221: SELECT null
222: FROM per_people_extra_info eiar
223: WHERE eiar.information_type = 'PQH_ACADEMIC_RANK'
224: AND paf.person_id = eiar.person_id
225: AND SYSDATE BETWEEN FND_DATE.canonical_to_date(eiar.PEI_INFORMATION2) AND
226: NVL(FND_DATE.canonical_to_date(eiar.PEI_INFORMATION3),SYSDATE))

Line 255: FROM per_people_extra_info ppe

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
256: WHERE ppe.information_type = 'PQH_TENURE_STATUS'
257: AND ppe.pei_information1 = p_tenure_status
258: AND paf.person_id = ppe.person_id
259: AND fnd_date.canonical_to_date(ppe.pei_information2) <= SYSDATE)

Line 313: per_people_extra_info ppe

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'
317: and assignment_type ='E'

Line 328: per_people_extra_info ppe

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'
332: AND ppe.information_type= 'PQH_TENURE_STATUS'

Line 342: per_people_extra_info ppe

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'
346: and assignment_type ='E'

Line 358: FROM per_people_extra_info ppe

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
359: WHERE ppe.information_type = 'PQH_TENURE_STATUS'
360: AND ppe.pei_information1 = l_tenure_status
361: AND paf.person_id = ppe.person_id
362: AND nvl(fnd_date.canonical_to_date(

Line 379: FROM per_people_extra_info ppe

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
380: WHERE ppe.information_type = 'PQH_TENURE_STATUS'
381: AND ppe.pei_information1 = l_tenure_status
382: AND paf.person_id = ppe.person_id
383: AND fnd_date.canonical_to_date(ppe.pei_information2)

Line 399: FROM per_people_extra_info ppe

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
400: WHERE ppe.information_type = 'PQH_TENURE_STATUS'
401: AND ppe.pei_information1 = l_tenure_status
402: AND paf.person_id = ppe.person_id
403: AND fnd_date.canonical_to_date(ppe.pei_information2) <= l_effective_date)