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_TYPES

Line 286: per_person_types ppt,

282: paf.business_group_id,
283: paf.assignment_id
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

Line 302: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.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)
306: )OR ppt.system_person_type IN ('EMP', 'CWK'));

Line 406: ,per_person_types pts

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
410: WHERE ppf.person_id = paf.person_id

Line 407: ,per_person_types_tl ptt

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
410: WHERE ppf.person_id = paf.person_id
411: AND (pts.system_person_type IN ('EMP','CWK') OR (paf.assignment_type = 'A' AND pts.system_person_type ='APL'))

Line 436: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)

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)
440: )

Line 494: ,per_person_types pts

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
498: WHERE ppf.person_id = paf.person_id

Line 495: ,per_person_types_tl ptt

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
498: WHERE ppf.person_id = paf.person_id
499: AND (pts.system_person_type IN (''EMP'',''CWK'') OR (paf.assignment_type = ''A'' AND pts.system_person_type =''APL''))

Line 524: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)

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)
528: )