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 836: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,'E',p_event_id ) completed_crs_prereq

832: p_per_bg_grp_prof_val number,
833: p_ota_global_bg_prof_val number
834: ) IS
835: SELECT ppf.person_id
836: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,'E',p_event_id ) completed_crs_prereq
837: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
838: , paf.organization_id
839: , paf.assignment_id
840: FROM per_all_people_f ppf

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

833: p_ota_global_bg_prof_val number
834: ) IS
835: SELECT ppf.person_id
836: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,'E',p_event_id ) completed_crs_prereq
837: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
838: , paf.organization_id
839: , paf.assignment_id
840: FROM per_all_people_f ppf
841: ,per_all_assignments_f paf

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

889: ) IS
890: SELECT ppf.person_id
891: , pjt.job_id Job_Id
892: , pps.position_id
893: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,'E',p_event_id ) completed_crs_prereq
894: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
895: , paf.organization_id
896: , paf.assignment_id
897: FROM per_all_people_f ppf

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

890: SELECT ppf.person_id
891: , pjt.job_id Job_Id
892: , pps.position_id
893: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,'E',p_event_id ) completed_crs_prereq
894: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
895: , paf.organization_id
896: , paf.assignment_id
897: FROM per_all_people_f ppf
898: ,per_all_assignments_f paf

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

1012: SELECT
1013: ppf.person_id person_id
1014: , pjt.job_id job_id
1015: , pps.position_id position_id
1016: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,''E'',:1 ) completed_crs_prereq
1017: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,:2) completed_comp_prereq
1018: , paf.organization_id organization_id
1019: , paf.assignment_id assignment_id
1020: FROM per_all_people_f ppf

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

1013: ppf.person_id person_id
1014: , pjt.job_id job_id
1015: , pps.position_id position_id
1016: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,''E'',:1 ) completed_crs_prereq
1017: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,:2) completed_comp_prereq
1018: , paf.organization_id organization_id
1019: , paf.assignment_id assignment_id
1020: FROM per_all_people_f ppf
1021: ,per_all_assignments_f paf

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

1215: p_per_bg_grp_prof_val number,
1216: p_ota_global_bg_prof_val number
1217: ) IS
1218: SELECT ppf.person_id
1219: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,'E',p_event_id ) completed_crs_prereq
1220: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
1221: , paf.organization_id
1222: , paf.assignment_id
1223: FROM per_all_people_f ppf

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

1216: p_ota_global_bg_prof_val number
1217: ) IS
1218: SELECT ppf.person_id
1219: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,'E',p_event_id ) completed_crs_prereq
1220: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
1221: , paf.organization_id
1222: , paf.assignment_id
1223: FROM per_all_people_f ppf
1224: ,per_all_assignments_f paf

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

1272: ) IS
1273: SELECT ppf.person_id
1274: , pjt.job_id Job_Id
1275: , pps.position_id
1276: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,'E',p_event_id ) completed_crs_prereq
1277: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
1278: , paf.organization_id
1279: , paf.assignment_id
1280: FROM per_all_people_f ppf

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

1273: SELECT ppf.person_id
1274: , pjt.job_id Job_Id
1275: , pps.position_id
1276: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,'E',p_event_id ) completed_crs_prereq
1277: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
1278: , paf.organization_id
1279: , paf.assignment_id
1280: FROM per_all_people_f ppf
1281: ,per_all_assignments_f paf

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

1467: SELECT
1468: ppf.person_id person_id
1469: , pjt.job_id job_id
1470: , pps.position_id position_id
1471: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,''E'',:1 ) completed_crs_prereq
1472: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,:2) completed_comp_prereq
1473: , paf.organization_id organization_id
1474: , paf.assignment_id assignment_id
1475: FROM per_all_people_f ppf

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

1468: ppf.person_id person_id
1469: , pjt.job_id job_id
1470: , pps.position_id position_id
1471: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,''E'',:1 ) completed_crs_prereq
1472: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,:2) completed_comp_prereq
1473: , paf.organization_id organization_id
1474: , paf.assignment_id assignment_id
1475: FROM per_all_people_f ppf
1476: ,per_all_assignments_f paf