APPS.OTA_CME_UTIL dependencies on OTA_GENERAL

Line 960: AND cre.BUSINESS_GROUP_ID = OTA_GENERAL.GET_BUSINESS_GROUP_ID

956: OTA_EVENTS evt
957: WHERE cre.person_id = p_person_id
958: AND cre.cert_enrollment_id = cpe.cert_enrollment_id
959: AND cme.cert_prd_enrollment_id = cpe.CERT_PRD_ENROLLMENT_ID
960: AND cre.BUSINESS_GROUP_ID = OTA_GENERAL.GET_BUSINESS_GROUP_ID
961: AND NVL(cre.IS_HISTORY_FLAG, 'N') = 'N'
962: AND evt.event_id = p_event_id
963: AND cmb.OBJECT_ID = evt.activity_version_id
964: AND cmb.OBJECT_TYPE = 'H'

Line 978: AND cre.BUSINESS_GROUP_ID = OTA_GENERAL.GET_BUSINESS_GROUP_ID

974: OTA_EVENTS evt
975: WHERE cre.contact_id = p_contact_id
976: AND cre.cert_enrollment_id = cpe.cert_enrollment_id
977: AND cme.cert_prd_enrollment_id = cpe.CERT_PRD_ENROLLMENT_ID
978: AND cre.BUSINESS_GROUP_ID = OTA_GENERAL.GET_BUSINESS_GROUP_ID
979: AND NVL(cre.IS_HISTORY_FLAG, 'N') = 'N'
980: AND evt.event_id = p_event_id
981: AND cmb.OBJECT_ID = evt.activity_version_id
982: AND cmb.OBJECT_TYPE = 'H'

Line 1020: AND cre.BUSINESS_GROUP_ID = OTA_GENERAL.GET_BUSINESS_GROUP_ID

1016: OTA_EVENTS evt
1017: WHERE cre.person_id = p_person_id
1018: AND cre.cert_enrollment_id = cpe.cert_enrollment_id
1019: AND cme.cert_prd_enrollment_id = cpe.CERT_PRD_ENROLLMENT_ID
1020: AND cre.BUSINESS_GROUP_ID = OTA_GENERAL.GET_BUSINESS_GROUP_ID
1021: AND NVL(cre.IS_HISTORY_FLAG, 'N') = 'N'
1022: AND evt.event_id = p_event_id
1023: AND cmb.OBJECT_ID = evt.activity_version_id
1024: AND cmb.OBJECT_TYPE = 'H'

Line 1038: AND cre.BUSINESS_GROUP_ID = OTA_GENERAL.GET_BUSINESS_GROUP_ID

1034: OTA_EVENTS evt
1035: WHERE cre.contact_id = p_contact_id
1036: AND cre.cert_enrollment_id = cpe.cert_enrollment_id
1037: AND cme.cert_prd_enrollment_id = cpe.CERT_PRD_ENROLLMENT_ID
1038: AND cre.BUSINESS_GROUP_ID = OTA_GENERAL.GET_BUSINESS_GROUP_ID
1039: AND NVL(cre.IS_HISTORY_FLAG, 'N') = 'N'
1040: AND evt.event_id = p_event_id
1041: AND cmb.OBJECT_ID = evt.activity_version_id
1042: AND cmb.OBJECT_TYPE = 'H'