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.OTA_MANDATORY_ENROLL_UTIL dependencies on PER_PERSON_TYPE_USAGES_F

Line 288: per_person_type_usages_f ptu

284: FROM
285: per_all_assignments_f paf,
286: per_person_types ppt,
287: per_all_people_f perp,
288: per_person_type_usages_f ptu
289: WHERE
290: paf.person_id = l_person_id
291: AND perp.person_id =paf.person_id
292: AND perp.person_id = ptu.person_id

Line 301: FROM per_person_type_usages_f ptf,

297: AND trunc(sysdate) BETWEEN paf.effective_start_date AND paf.effective_end_date
298: AND trunc(sysdate) BETWEEN ptu.effective_start_date AND ptu.effective_end_date
299: AND ((ppt.system_person_type = 'APL'
300: AND NOT EXISTS (SELECT person_id
301: FROM per_person_type_usages_f ptf,
302: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
303: AND ptf.person_type_id = ptp.person_type_id
304: AND ptp.system_person_type IN ('EMP', 'CWK')
305: AND ptf.person_id = paf.PERSON_ID)

Line 405: ,per_person_type_usages_f ptu

401: FROM per_all_people_f ppf
402: ,per_all_assignments_f paf
403: ,per_jobs_tl pjt
404: ,per_all_positions pps
405: ,per_person_type_usages_f ptu
406: ,per_person_types pts
407: ,per_person_types_tl ptt
408: ,hr_all_organization_units_tl orgTl
409: ,per_business_groups pbg

Line 435: FROM per_person_type_usages_f ptf,

431: AND paf.business_group_id = pbg.business_group_id
432: AND
433: ((pts.system_person_type = 'APL'
434: AND NOT EXISTS (SELECT person_id
435: FROM per_person_type_usages_f ptf,
436: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
437: AND ptf.person_type_id = ptp.person_type_id
438: AND ptp.system_person_type IN ('EMP', 'CWK')
439: AND ptf.person_id = ppf.PERSON_ID)

Line 493: ,per_person_type_usages_f ptu

489: FROM per_all_people_f ppf
490: ,per_all_assignments_f paf
491: ,per_jobs_tl pjt
492: ,per_all_positions pps
493: ,per_person_type_usages_f ptu
494: ,per_person_types pts
495: ,per_person_types_tl ptt
496: ,hr_all_organization_units_tl orgTl
497: ,per_business_groups pbg

Line 523: FROM per_person_type_usages_f ptf,

519: AND paf.business_group_id = pbg.business_group_id
520: AND
521: ((pts.system_person_type = ''APL''
522: AND NOT EXISTS (SELECT person_id
523: FROM per_person_type_usages_f ptf,
524: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
525: AND ptf.person_type_id = ptp.person_type_id
526: AND ptp.system_person_type IN (''EMP'', ''CWK'')
527: AND ptf.person_id = ppf.PERSON_ID)