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 OTA_CERTIFICATIONS_B

Line 482: ,p_certification_id IN ota_certifications_b.certification_id%type default NULL)

478:
479:
480: FUNCTION learner_is_notSelected_inCert(p_person_id IN per_all_people_f.person_id%type
481: ,p_assignment_id per_all_assignments_f.assignment_id%type
482: ,p_certification_id IN ota_certifications_b.certification_id%type default NULL)
483: RETURN Boolean IS
484:
485: CURSOR lrnr_already_selected IS
486: SELECT assignment_id

Line 2296: ota_certifications_b cert

2292: l_rec.enr_prereq_type,l_rec.event_id,l_rec.person_id,l_rec.organization_id,l_rec.job_id,l_rec.position_id,
2293: l_rec.org_structure_version_id,l_rec.user_group_id,l_rec.requestor_id,l_rec.certification_id
2294: FROM
2295: ota_event_associations oea ,
2296: ota_certifications_b cert
2297: WHERE oea.certification_id = cert.certification_id
2298: AND oea.MANDATORY_ENROLLMENT_FLAG = 'Y'
2299: AND trunc(sysdate) BETWEEN trunc(cert.start_date_active) and nvl(cert.end_date_active, trunc(sysdate))
2300: AND nvl(p_cert_id,-1)= decode(p_cert_id,NULL,-1,cert.certification_id)