APPS.OTA_CPE_UTIL dependencies on OTA_CERTIFICATIONS_B

Line 435: from ota_certifications_b b,

431: b.certification_id certification_id
432: , b.RENEWABLE_FLAG
433: , b.INITIAL_COMPLETION_DURATION
434: , cre.expiration_date
435: from ota_certifications_b b,
436: ota_cert_enrollments cre
437: where cre.certification_id = b.certification_id
438: and cre.cert_enrollment_id = p_cert_enrollment_id;
439:

Line 555: from ota_certifications_b b,

551: , b.VALIDITY_START_TYPE
552: , b.PUBLIC_FLAG
553: , b.START_DATE_ACTIVE
554: , b.END_DATE_ACTIVE
555: from ota_certifications_b b,
556: ota_cert_enrollments cre
557: where cre.certification_id = b.certification_id
558: and cre.cert_enrollment_id = p_cert_enrollment_id;
559:

Line 639: from ota_certifications_b b

635: , b.VALIDITY_START_TYPE
636: , b.PUBLIC_FLAG
637: , b.START_DATE_ACTIVE
638: , b.END_DATE_ACTIVE
639: from ota_certifications_b b
640: where certification_id = p_certification_id;
641:
642:
643: CURSOR csr_cre IS

Line 647: from ota_certifications_b b,

643: CURSOR csr_cre IS
644: select
645: trunc(cre.earliest_enroll_date) earliest_enroll_date --bug#8775942
646: , trunc(cre.expiration_date) expiration_date
647: from ota_certifications_b b,
648: ota_cert_enrollments cre
649: where cre.certification_id = b.certification_id
650: and cre.cert_enrollment_id = p_cert_enrollment_id;
651:

Line 848: from ota_certifications_b b,

844: , b.START_DATE_ACTIVE
845: , b.END_DATE_ACTIVE
846: , cre.expiration_date
847: , b.renewable_flag --Bug 4545407
848: from ota_certifications_b b,
849: ota_cert_enrollments cre
850: where cre.certification_id = b.certification_id
851: and cre.cert_enrollment_id = p_cert_enrollment_id;
852:

Line 1012: ota_certifications_b crt

1008: crt.renewable_flag,
1009: cre.expiration_date,
1010: nvl(crt.end_date_active,to_date('4712/12/31','YYYY/MM/DD')) end_date_active
1011: From ota_cert_enrollments cre,
1012: ota_certifications_b crt
1013: where cre.cert_enrollment_id = p_cert_enrollment_id
1014: and crt.certification_id = cre.certification_id;
1015:
1016: l_proc VARCHAR2(72) := g_package||' get_cre_status';

Line 1129: ota_certifications_b crt

1125: crt.validity_duration,
1126: crt.validity_start_type
1127: FROM ota_cert_enrollments cre,
1128: ota_cert_prd_enrollments cpe,
1129: ota_certifications_b crt
1130: where cpe.cert_prd_enrollment_id = p_cert_prd_enrollment_id
1131: and cre.certification_id = crt.certification_id
1132: and cpe.cert_enrollment_id = cre.cert_enrollment_id;
1133:

Line 1237: from ota_certifications_b b

1233: , b.VALIDITY_START_TYPE
1234: , b.PUBLIC_FLAG
1235: , b.START_DATE_ACTIVE
1236: , b.END_DATE_ACTIVE
1237: from ota_certifications_b b
1238: where b.certification_id = p_certification_id;
1239:
1240: CURSOR csr_cert_mbr(p_certification_id in ota_cert_enrollments.certification_id%type) IS
1241: select

Line 2134: function get_elapsed_due_date(p_certification_id ota_certifications_b.certification_id%type) return date is

2130: RETURN null;
2131:
2132: End get_latest_cpe_col;
2133:
2134: function get_elapsed_due_date(p_certification_id ota_certifications_b.certification_id%type) return date is
2135: CURSOR csr_crt IS
2136: select
2137: b.certification_id certification_id
2138: , b.INITIAL_COMPLETION_DATE

Line 2142: from ota_certifications_b b

2138: , b.INITIAL_COMPLETION_DATE
2139: , b.VALIDITY_DURATION
2140: , b.VALIDITY_DURATION_UNITS
2141: , b.renewable_flag
2142: from ota_certifications_b b
2143: where b.certification_id = p_certification_id;
2144:
2145:
2146: l_proc VARCHAR2(72) := g_package||' get_elapsed_due_date';