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_CPR_UTILITY

Line 397: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,'E',p_event_id ) completed_crs_prereq

393: ) IS
394: SELECT ppf.person_id
395: , pjt.job_id Job_Id
396: , pps.position_id
397: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,'E',p_event_id ) completed_crs_prereq
398: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
399: , paf.organization_id
400: , paf.assignment_id
401: FROM per_all_people_f ppf

Line 398: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq

394: SELECT ppf.person_id
395: , pjt.job_id Job_Id
396: , pps.position_id
397: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,'E',p_event_id ) completed_crs_prereq
398: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
399: , paf.organization_id
400: , paf.assignment_id
401: FROM per_all_people_f ppf
402: ,per_all_assignments_f paf

Line 485: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,''E'',:1 ) completed_crs_prereq

481: SELECT
482: ppf.person_id person_id
483: , pjt.job_id job_id
484: , pps.position_id position_id
485: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,''E'',:1 ) completed_crs_prereq
486: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,:2) completed_comp_prereq
487: , paf.organization_id organization_id
488: , paf.assignment_id assignment_id
489: FROM per_all_people_f ppf

Line 486: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,:2) completed_comp_prereq

482: ppf.person_id person_id
483: , pjt.job_id job_id
484: , pps.position_id position_id
485: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,''E'',:1 ) completed_crs_prereq
486: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,:2) completed_comp_prereq
487: , paf.organization_id organization_id
488: , paf.assignment_id assignment_id
489: FROM per_all_people_f ppf
490: ,per_all_assignments_f paf