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.HR_WPM_UTIL dependencies on FND_DATE

Line 335: fnd_date.canonical_to_date (pei_information5) start_date,

331: CURSOR csr_pot_new_eit (p_person_id NUMBER, p_effective_date DATE)
332: IS
333: SELECT potential
334: FROM (SELECT pei_information1 potential,
335: fnd_date.canonical_to_date (pei_information5) start_date,
336: fnd_date.canonical_to_date (pei_information6) end_date,
337: fnd_date.canonical_to_date (pei_information8) completion_date
338: FROM per_people_extra_info
339: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')

Line 336: fnd_date.canonical_to_date (pei_information6) end_date,

332: IS
333: SELECT potential
334: FROM (SELECT pei_information1 potential,
335: fnd_date.canonical_to_date (pei_information5) start_date,
336: fnd_date.canonical_to_date (pei_information6) end_date,
337: fnd_date.canonical_to_date (pei_information8) completion_date
338: FROM per_people_extra_info
339: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')
340: WHERE (NVL (start_date, p_effective_date) <= p_effective_date)

Line 337: fnd_date.canonical_to_date (pei_information8) completion_date

333: SELECT potential
334: FROM (SELECT pei_information1 potential,
335: fnd_date.canonical_to_date (pei_information5) start_date,
336: fnd_date.canonical_to_date (pei_information6) end_date,
337: fnd_date.canonical_to_date (pei_information8) completion_date
338: FROM per_people_extra_info
339: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')
340: WHERE (NVL (start_date, p_effective_date) <= p_effective_date)
341: ORDER BY NVL (completion_date, start_date) DESC;

Line 513: fnd_date.canonical_to_date (pei_information5) start_date,

509: CURSOR csr_ret_new_eit (p_person_id NUMBER, p_effective_date DATE)
510: IS
511: SELECT RETENTION
512: FROM (SELECT pei_information4 RETENTION,
513: fnd_date.canonical_to_date (pei_information5) start_date,
514: fnd_date.canonical_to_date (pei_information6) end_date,
515: fnd_date.canonical_to_date (pei_information8) completion_date
516: FROM per_people_extra_info
517: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')

Line 514: fnd_date.canonical_to_date (pei_information6) end_date,

510: IS
511: SELECT RETENTION
512: FROM (SELECT pei_information4 RETENTION,
513: fnd_date.canonical_to_date (pei_information5) start_date,
514: fnd_date.canonical_to_date (pei_information6) end_date,
515: fnd_date.canonical_to_date (pei_information8) completion_date
516: FROM per_people_extra_info
517: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')
518: WHERE (NVL (start_date, p_effective_date) <= p_effective_date)

Line 515: fnd_date.canonical_to_date (pei_information8) completion_date

511: SELECT RETENTION
512: FROM (SELECT pei_information4 RETENTION,
513: fnd_date.canonical_to_date (pei_information5) start_date,
514: fnd_date.canonical_to_date (pei_information6) end_date,
515: fnd_date.canonical_to_date (pei_information8) completion_date
516: FROM per_people_extra_info
517: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')
518: WHERE (NVL (start_date, p_effective_date) <= p_effective_date)
519: ORDER BY NVL (completion_date, start_date) DESC;

Line 716: fnd_date.canonical_to_date (pei_information5) start_date,

712: CURSOR csr_iol_eit (p_person_id NUMBER, p_effective_date DATE)
713: IS
714: SELECT iol
715: FROM (SELECT pei_information9 iol,
716: fnd_date.canonical_to_date (pei_information5) start_date,
717: fnd_date.canonical_to_date (pei_information6) end_date,
718: fnd_date.canonical_to_date (pei_information8) completion_date
719: FROM per_people_extra_info
720: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')

Line 717: fnd_date.canonical_to_date (pei_information6) end_date,

713: IS
714: SELECT iol
715: FROM (SELECT pei_information9 iol,
716: fnd_date.canonical_to_date (pei_information5) start_date,
717: fnd_date.canonical_to_date (pei_information6) end_date,
718: fnd_date.canonical_to_date (pei_information8) completion_date
719: FROM per_people_extra_info
720: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')
721: WHERE (NVL (start_date, p_effective_date) <= p_effective_date)

Line 718: fnd_date.canonical_to_date (pei_information8) completion_date

714: SELECT iol
715: FROM (SELECT pei_information9 iol,
716: fnd_date.canonical_to_date (pei_information5) start_date,
717: fnd_date.canonical_to_date (pei_information6) end_date,
718: fnd_date.canonical_to_date (pei_information8) completion_date
719: FROM per_people_extra_info
720: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')
721: WHERE (NVL (start_date, p_effective_date) <= p_effective_date)
722: ORDER BY NVL (completion_date, start_date) DESC;

Line 969: fnd_date.canonical_to_date (pei_information5) start_date,

965: CURSOR csr_key_worker_eit (p_person_id NUMBER, p_effective_date DATE)
966: IS
967: SELECT key_worker
968: FROM (SELECT pei_information3 key_worker,
969: fnd_date.canonical_to_date (pei_information5) start_date,
970: fnd_date.canonical_to_date (pei_information6) end_date,
971: fnd_date.canonical_to_date (pei_information8) completion_date
972: FROM per_people_extra_info
973: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')

Line 970: fnd_date.canonical_to_date (pei_information6) end_date,

966: IS
967: SELECT key_worker
968: FROM (SELECT pei_information3 key_worker,
969: fnd_date.canonical_to_date (pei_information5) start_date,
970: fnd_date.canonical_to_date (pei_information6) end_date,
971: fnd_date.canonical_to_date (pei_information8) completion_date
972: FROM per_people_extra_info
973: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')
974: WHERE (NVL (start_date, p_effective_date) <= p_effective_date)

Line 971: fnd_date.canonical_to_date (pei_information8) completion_date

967: SELECT key_worker
968: FROM (SELECT pei_information3 key_worker,
969: fnd_date.canonical_to_date (pei_information5) start_date,
970: fnd_date.canonical_to_date (pei_information6) end_date,
971: fnd_date.canonical_to_date (pei_information8) completion_date
972: FROM per_people_extra_info
973: WHERE person_id = p_person_id AND information_type = 'PER_SUCCESSION_MGMT_INFO')
974: WHERE (NVL (start_date, p_effective_date) <= p_effective_date)
975: ORDER BY NVL (completion_date, start_date) DESC;