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 933: FUNCTION get_cert_mbr_status (p_cert_mbr_id in ota_certification_members.certification_member_id%TYPE,

929: RETURN null;
930:
931: end get_next_prd_dur_days;
932: --
933: FUNCTION get_cert_mbr_status (p_cert_mbr_id in ota_certification_members.certification_member_id%TYPE,
934: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
935: p_code in number default 1)
936: RETURN varchar2 is
937:

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

957: return l_member_status;
958: end if;
959: End get_cert_mbr_status;
960: --
961: FUNCTION get_cert_mbr_name (p_cert_mbr_id in ota_certification_members.certification_member_id%TYPE)
962: RETURN varchar2 is
963:
964: Cursor get_cert_mbr_data is
965: Select object_id, object_type

Line 966: From ota_certification_members

962: RETURN varchar2 is
963:
964: Cursor get_cert_mbr_data 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

Line 974: l_object_id ota_certification_members.object_id%TYPE;

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;
976: l_member_name varchar2(240);
977: Begin
978: Open get_cert_mbr_data;

Line 975: l_object_type ota_certification_members.object_type%TYPE;

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;
976: l_member_name varchar2(240);
977: Begin
978: Open get_cert_mbr_data;
979: Fetch get_cert_mbr_data into l_object_id, l_object_type;

Line 1240: from ota_certification_members cmb

1236: , cmb.OBJECT_TYPE
1237: , cmb.MEMBER_SEQUENCE
1238: , cmb.START_DATE_ACTIVE
1239: , cmb.END_DATE_ACTIVE
1240: from ota_certification_members cmb
1241: where cmb.certification_id = p_certification_id
1242: and trunc(sysdate) between trunc(cmb.START_DATE_ACTIVE) and nvl(trunc(cmb.end_date_active), to_date('4712/12/31', 'YYYY/MM/DD'));
1243:
1244: CURSOR csr_cert_enrl IS

Line 1987: ota_certification_members cmb

1983: is
1984: select cme.cert_mbr_enrollment_id,
1985: cmb.object_id
1986: from ota_cert_mbr_enrollments cme,
1987: ota_certification_members cmb
1988: where cme.cert_prd_enrollment_id = p_cert_prd_enrollment_id
1989: and cme.cert_member_id = cmb.certification_member_id
1990: and object_type = 'H';
1991:

Line 2168: FROM ota_certification_members cmb,

2164: and ofr.activity_version_id = act.activity_version_id;
2165:
2166: CURSOR csr_chk_prds(l_activity_version_id number) IS
2167: SELECT null
2168: FROM ota_certification_members cmb,
2169: ota_cert_mbr_enrollments cme,
2170: ota_cert_prd_enrollments cpe,
2171: ota_cert_enrollments cre
2172: WHERE

Line 2316: ota_certification_members cmb

2312: CURSOR csr_course_info(p_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) is
2313: SELECT cme.cert_mbr_enrollment_id,
2314: cmb.object_id
2315: FROM ota_cert_mbr_enrollments cme,
2316: ota_certification_members cmb
2317: WHERE cme.cert_prd_enrollment_id = p_cert_prd_enrollment_id
2318: AND cme.cert_member_id = cmb.certification_member_id
2319: AND object_type = 'H'
2320: AND member_status_code = 'PLANNED';