eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_TENURE_DETAIL dependencies on FND_DATE

Line 47: FND_DATE.canonical_to_date(PEI_INFORMATION2) date_determined,

43: p_completed_months OUT NOCOPY VARCHAR2 ) IS
44:
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' ;

Line 48: FND_DATE.canonical_to_date(nvl(PEI_INFORMATION4,PEI_INFORMATION3)) adjusted_tenure_date

44:
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:

Line 62: p_date_determine := fnd_date.date_to_displaydate(l_date_determine);

58: OPEN emp_tenure_cur;
59: FETCH emp_tenure_cur INTO p_tenure_status, l_date_determine, l_adjust_date;
60: CLOSE emp_tenure_cur;
61:
62: p_date_determine := fnd_date.date_to_displaydate(l_date_determine);
63: p_adjust_date := fnd_date.date_to_displaydate(l_adjust_date);
64:
65: p_remain_years := TRUNC((l_adjust_date - trunc(SYSDATE) ) / 365 );
66: p_remain_months := ROUND( MOD ((l_adjust_date - trunc(SYSDATE)) , 365) / 30 );

Line 63: p_adjust_date := fnd_date.date_to_displaydate(l_adjust_date);

59: FETCH emp_tenure_cur INTO p_tenure_status, l_date_determine, l_adjust_date;
60: CLOSE emp_tenure_cur;
61:
62: p_date_determine := fnd_date.date_to_displaydate(l_date_determine);
63: p_adjust_date := fnd_date.date_to_displaydate(l_adjust_date);
64:
65: p_remain_years := TRUNC((l_adjust_date - trunc(SYSDATE) ) / 365 );
66: p_remain_months := ROUND( MOD ((l_adjust_date - trunc(SYSDATE)) , 365) / 30 );
67:

Line 189: AND FND_DATE.canonical_to_date(PEI_INFORMATION2) <= p_effective_date

185: and assignment_type ='E' -- only employees
186: AND ppe.information_type = 'PQH_TENURE_STATUS'
187: AND ppe.pei_information1 = p_tenure_status
188: AND SYSDATE BETWEEN paf.effective_start_date AND paf.effective_end_date
189: AND FND_DATE.canonical_to_date(PEI_INFORMATION2) <= p_effective_date
190: AND paf.supervisor_id = p_supervisor_id ;
191:
192: l_status_count NUMBER;
193:

Line 219: AND FND_DATE.canonical_to_date(PPE.PEI_INFORMATION2) BETWEEN p_start_date AND p_end_date)

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)
220: and exists (
221: SELECT null
222: FROM per_people_extra_info eiar
223: WHERE eiar.information_type = 'PQH_ACADEMIC_RANK'

Line 225: AND SYSDATE BETWEEN FND_DATE.canonical_to_date(eiar.PEI_INFORMATION2) AND

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))
227: CONNECT BY PRIOR person_id = supervisor_id
228: AND SYSDATE BETWEEN effective_start_date AND effective_end_date
229: AND primary_flag ='Y'

Line 226: NVL(FND_DATE.canonical_to_date(eiar.PEI_INFORMATION3),SYSDATE))

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))
227: CONNECT BY PRIOR person_id = supervisor_id
228: AND SYSDATE BETWEEN effective_start_date AND effective_end_date
229: AND primary_flag ='Y'
230: START WITH supervisor_id = p_supervisor_id

Line 259: AND fnd_date.canonical_to_date(ppe.pei_information2) <= SYSDATE)

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)
260: CONNECT BY PRIOR person_id = supervisor_id
261: AND SYSDATE BETWEEN effective_start_date AND effective_end_date
262: AND primary_flag ='Y'
263: START WITH supervisor_id = p_supervisor_id

Line 321: AND nvl(fnd_date.canonical_to_date(NVL(ppe.pei_information4,ppe.pei_information3)),sysdate)

317: and assignment_type ='E'
318: AND ppe.pei_information1 = l_tenure_status
319: AND paf.effective_start_date <= SYSDATE
320: AND paf.effective_end_date >= SYSDATE
321: AND nvl(fnd_date.canonical_to_date(NVL(ppe.pei_information4,ppe.pei_information3)),sysdate)
322: BETWEEN p_start_academic_dt AND p_end_academic_dt;
323:
324: /* Faculty count of Tenure Status for current Year */
325: CURSOR prsn_ed_cnt_cur IS

Line 335: AND fnd_date.canonical_to_date(ppe.pei_information2) BETWEEN

331: and assignment_type ='E'
332: AND ppe.information_type= 'PQH_TENURE_STATUS'
333: AND ppe.pei_information1= l_tenure_status
334: AND SYSDATE BETWEEN paf.effective_start_date AND paf.effective_end_date
335: AND fnd_date.canonical_to_date(ppe.pei_information2) BETWEEN
336: p_start_academic_dt AND p_end_academic_dt;
337:
338: /* Faculty count of Tenure Status upto to start date */
339: CURSOR prsn_cnt_tillnow_cur IS

Line 349: AND fnd_date.canonical_to_date(ppe.pei_information2) <= l_effective_date;

345: and primary_flag ='Y'
346: and assignment_type ='E'
347: AND ppe.pei_information1= l_tenure_status
348: AND SYSDATE BETWEEN paf.effective_start_date AND paf.effective_end_date
349: AND fnd_date.canonical_to_date(ppe.pei_information2) <= l_effective_date;
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)

Line 362: AND nvl(fnd_date.canonical_to_date(

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(
363: NVL(ppe.pei_information4,ppe.pei_information3)),SYSDATE)
364: BETWEEN p_start_academic_dt AND p_end_academic_dt)
365: CONNECT BY PRIOR person_id = supervisor_id
366: AND SYSDATE BETWEEN effective_start_date AND effective_end_date

Line 383: AND fnd_date.canonical_to_date(ppe.pei_information2)

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)
384: BETWEEN p_start_academic_dt AND p_end_academic_dt)
385: CONNECT BY PRIOR person_id = supervisor_id
386: AND SYSDATE BETWEEN effective_start_date AND effective_end_date
387: AND primary_flag ='Y'

Line 403: AND fnd_date.canonical_to_date(ppe.pei_information2) <= l_effective_date)

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)
404: CONNECT BY PRIOR person_id = supervisor_id
405: AND SYSDATE BETWEEN effective_start_date AND effective_end_date
406: AND primary_flag ='Y'
407: START WITH supervisor_id = p_supervisor_id