APPS.OTA_CPE_UTIL dependencies on OTA_ACTIVITY_VERSIONS

Line 28: ota_activity_versions tav,

24: cpe.cert_period_start_date,
25: cpe.cert_period_end_date,
26: cre.certification_id
27: from
28: ota_activity_versions tav,
29: ota_cert_enrollments cre,
30: ota_cert_prd_enrollments cpe,
31: ota_cert_mbr_enrollments cme,
32: ota_certification_members cmb,

Line 96: ota_activity_versions tav,

92: Select
93: tav.activity_version_id
94:
95: FROM
96: ota_activity_versions tav,
97: -- ota_cert_enrollments cre,
98: ota_cert_prd_enrollments cpe,
99: ota_cert_mbr_enrollments cme,
100: ota_certification_members cmb

Line 113: Cursor Csr_Crt_mbr_cls_status(p_act_version_id ota_activity_versions.activity_version_id%Type

109: -- AND tav.activity_version_id= evt.activity_version_id
110: AND cpe.cert_prd_enrollment_id =p_cert_prd_enrollment_id; -- 640, 350, 349
111:
112:
113: Cursor Csr_Crt_mbr_cls_status(p_act_version_id ota_activity_versions.activity_version_id%Type
114: ) is
115: Select tdb.successful_attendance_flag
116: From ota_events evt,ota_delegate_bookings tdb,ota_booking_status_types bst
117: Where

Line 969: Cursor get_course_name(p_act_ver_id in ota_activity_versions.activity_version_id%TYPE) is

965: Select object_id, object_type
966: From ota_certification_members
967: Where certification_member_id = p_cert_mbr_id;
968:
969: Cursor get_course_name(p_act_ver_id in ota_activity_versions.activity_version_id%TYPE) is
970: Select version_name
971: From ota_activity_versions_vl
972: Where activity_version_id = p_act_ver_id;
973:

Line 971: From ota_activity_versions_vl

967: Where certification_member_id = p_cert_mbr_id;
968:
969: Cursor get_course_name(p_act_ver_id in ota_activity_versions.activity_version_id%TYPE) is
970: Select version_name
971: From ota_activity_versions_vl
972: Where activity_version_id = p_act_ver_id;
973:
974: l_object_id ota_certification_members.object_id%TYPE;
975: l_object_type ota_certification_members.object_type%TYPE;

Line 2161: from ota_activity_versions act,

2157: and ofr.delivery_mode_id = csu.category_usage_id;
2158:
2159: cursor csr_act_id(csr_offering_id number) is
2160: select act.activity_version_id
2161: from ota_activity_versions act,
2162: ota_offerings ofr
2163: where ofr.offering_id = csr_offering_id
2164: and ofr.activity_version_id = act.activity_version_id;
2165:

Line 2188: l_activity_version_id ota_activity_versions.activity_version_id%type;

2184:
2185: rec_onl_sync_flag csr_onl_sync_flag%rowtype;
2186:
2187: is_evt_onl_async boolean := false;
2188: l_activity_version_id ota_activity_versions.activity_version_id%type;
2189:
2190: l_return_value varchar2(1) := 'N';
2191:
2192: l_dummy varchar2(10);

Line 2322: CURSOR get_enrl_status(csr_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

2318: AND cme.cert_member_id = cmb.certification_member_id
2319: AND object_type = 'H'
2320: AND member_status_code = 'PLANNED';
2321:
2322: CURSOR get_enrl_status(csr_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
2323: csr_cert_period_start_date in ota_cert_prd_enrollments.cert_period_start_date%type,
2324: csr_cert_period_end_date in ota_cert_prd_enrollments.cert_period_end_date%type,
2325: csr_person_id in ota_cert_enrollments.person_id%TYPE,
2326: csr_contact_id in ota_cert_enrollments.contact_id%TYPE) IS