APPS.OTA_LRNG_PATH_UTIL dependencies on OTA_GENERAL

Line 1045: AND lpe.business_group_id = ota_general.get_business_group_id

1041: WHERE lpe.person_id = p_person_id
1042: AND oev.event_id = p_event_id
1043: AND NVL(lpe.is_history_flag, 'N') = 'N'
1044: AND lpe.path_status_code NOT IN ('CANCELLED', 'REJECTED', 'AWAITING_APPROVAL')
1045: AND lpe.business_group_id = ota_general.get_business_group_id
1046: AND oev.activity_version_id = lpm.activity_version_id
1047: AND lpe.learning_path_id = lpm.learning_path_id;
1048:
1049: CURSOR csr_lp_enrl_id_contact IS

Line 1058: AND lpe.business_group_id = ota_general.get_business_group_id

1054: WHERE lpe.contact_id = p_contact_id
1055: AND oev.event_id = p_event_id
1056: AND NVL(lpe.is_history_flag, 'N') = 'N'
1057: AND lpe.path_status_code NOT IN ('CANCELLED', 'REJECTED', 'AWAITING_APPROVAL')
1058: AND lpe.business_group_id = ota_general.get_business_group_id
1059: AND oev.activity_version_id = lpm.activity_version_id
1060: AND lpe.learning_path_id = lpm.learning_path_id;
1061:
1062: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%type;