APPS.OTA_CPE_UTIL dependencies on OTA_CERTIFICATION_MEMBERS

Line 32: ota_certification_members cmb,

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,
33: ota_events evt
34:
35: where evt.event_id = p_event_id
36: and evt.activity_version_id = tav.activity_version_id

Line 100: ota_certification_members cmb

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
101:
102: WHERE
103: cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
104: -- AND cre.cert_enrollment_id = cpe.cert_enrollment_id

Line 941: FUNCTION get_cert_mbr_status (p_cert_mbr_id in ota_certification_members.certification_member_id%TYPE,

937: RETURN null;
938:
939: end get_next_prd_dur_days;
940: --
941: FUNCTION get_cert_mbr_status (p_cert_mbr_id in ota_certification_members.certification_member_id%TYPE,
942: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
943: p_code in number default 1)
944: RETURN varchar2 is
945:

Line 969: FUNCTION get_cert_mbr_name (p_cert_mbr_id in ota_certification_members.certification_member_id%TYPE)

965: return l_member_status;
966: end if;
967: End get_cert_mbr_status;
968: --
969: FUNCTION get_cert_mbr_name (p_cert_mbr_id in ota_certification_members.certification_member_id%TYPE)
970: RETURN varchar2 is
971:
972: Cursor get_cert_mbr_data is
973: Select object_id, object_type

Line 974: From ota_certification_members

970: RETURN varchar2 is
971:
972: Cursor get_cert_mbr_data is
973: Select object_id, object_type
974: From ota_certification_members
975: Where certification_member_id = p_cert_mbr_id;
976:
977: Cursor get_course_name(p_act_ver_id in ota_activity_versions.activity_version_id%TYPE) is
978: Select version_name

Line 982: l_object_id ota_certification_members.object_id%TYPE;

978: Select version_name
979: From ota_activity_versions_vl
980: Where activity_version_id = p_act_ver_id;
981:
982: l_object_id ota_certification_members.object_id%TYPE;
983: l_object_type ota_certification_members.object_type%TYPE;
984: l_member_name varchar2(240);
985: Begin
986: Open get_cert_mbr_data;

Line 983: l_object_type ota_certification_members.object_type%TYPE;

979: From ota_activity_versions_vl
980: Where activity_version_id = p_act_ver_id;
981:
982: l_object_id ota_certification_members.object_id%TYPE;
983: l_object_type ota_certification_members.object_type%TYPE;
984: l_member_name varchar2(240);
985: Begin
986: Open get_cert_mbr_data;
987: Fetch get_cert_mbr_data into l_object_id, l_object_type;

Line 1249: from ota_certification_members cmb

1245: , cmb.OBJECT_TYPE
1246: , cmb.MEMBER_SEQUENCE
1247: , cmb.START_DATE_ACTIVE
1248: , cmb.END_DATE_ACTIVE
1249: from ota_certification_members cmb
1250: where cmb.certification_id = p_certification_id
1251: and trunc(sysdate) between trunc(cmb.START_DATE_ACTIVE) and nvl(trunc(cmb.end_date_active), to_date('4712/12/31', 'YYYY/MM/DD'));
1252:
1253: CURSOR csr_cert_enrl IS

Line 2026: ota_certification_members cmb

2022: is
2023: select cme.cert_mbr_enrollment_id,
2024: cmb.object_id
2025: from ota_cert_mbr_enrollments cme,
2026: ota_certification_members cmb
2027: where cme.cert_prd_enrollment_id = p_cert_prd_enrollment_id
2028: and cme.cert_member_id = cmb.certification_member_id
2029: and object_type = 'H';
2030:

Line 2207: FROM ota_certification_members cmb,

2203: and ofr.activity_version_id = act.activity_version_id;
2204:
2205: CURSOR csr_chk_prds(l_activity_version_id number) IS
2206: SELECT null
2207: FROM ota_certification_members cmb,
2208: ota_cert_mbr_enrollments cme,
2209: ota_cert_prd_enrollments cpe,
2210: ota_cert_enrollments cre
2211: WHERE

Line 2355: ota_certification_members cmb

2351: CURSOR csr_course_info(p_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) is
2352: SELECT cme.cert_mbr_enrollment_id,
2353: cmb.object_id
2354: FROM ota_cert_mbr_enrollments cme,
2355: ota_certification_members cmb
2356: WHERE cme.cert_prd_enrollment_id = p_cert_prd_enrollment_id
2357: AND cme.cert_member_id = cmb.certification_member_id
2358: AND object_type = 'H'
2359: AND member_status_code = 'PLANNED';