APPS.OTA_CPE_UTIL dependencies on OTA_CERTIFICATIONS_B

Line 427: from ota_certifications_b b,

423: b.certification_id certification_id
424: , b.RENEWABLE_FLAG
425: , b.INITIAL_COMPLETION_DURATION
426: , cre.expiration_date
427: from ota_certifications_b b,
428: ota_cert_enrollments cre
429: where cre.certification_id = b.certification_id
430: and cre.cert_enrollment_id = p_cert_enrollment_id;
431:

Line 547: from ota_certifications_b b,

543: , b.VALIDITY_START_TYPE
544: , b.PUBLIC_FLAG
545: , b.START_DATE_ACTIVE
546: , b.END_DATE_ACTIVE
547: from ota_certifications_b b,
548: ota_cert_enrollments cre
549: where cre.certification_id = b.certification_id
550: and cre.cert_enrollment_id = p_cert_enrollment_id;
551:

Line 631: from ota_certifications_b b

627: , b.VALIDITY_START_TYPE
628: , b.PUBLIC_FLAG
629: , b.START_DATE_ACTIVE
630: , b.END_DATE_ACTIVE
631: from ota_certifications_b b
632: where certification_id = p_certification_id;
633:
634:
635: CURSOR csr_cre IS

Line 639: from ota_certifications_b b,

635: CURSOR csr_cre IS
636: select
637: cre.earliest_enroll_date
638: , cre.expiration_date
639: from ota_certifications_b b,
640: ota_cert_enrollments cre
641: where cre.certification_id = b.certification_id
642: and cre.cert_enrollment_id = p_cert_enrollment_id;
643:

Line 840: from ota_certifications_b b,

836: , b.START_DATE_ACTIVE
837: , b.END_DATE_ACTIVE
838: , cre.expiration_date
839: , b.renewable_flag --Bug 4545407
840: from ota_certifications_b b,
841: ota_cert_enrollments cre
842: where cre.certification_id = b.certification_id
843: and cre.cert_enrollment_id = p_cert_enrollment_id;
844:

Line 1004: ota_certifications_b crt

1000: crt.renewable_flag,
1001: cre.expiration_date,
1002: nvl(crt.end_date_active,to_date('4712/12/31','YYYY/MM/DD')) end_date_active
1003: From ota_cert_enrollments cre,
1004: ota_certifications_b crt
1005: where cre.cert_enrollment_id = p_cert_enrollment_id
1006: and crt.certification_id = cre.certification_id;
1007:
1008: l_proc VARCHAR2(72) := g_package||' get_cre_status';

Line 1121: ota_certifications_b crt

1117: crt.validity_duration,
1118: crt.validity_start_type
1119: FROM ota_cert_enrollments cre,
1120: ota_cert_prd_enrollments cpe,
1121: ota_certifications_b crt
1122: where cpe.cert_prd_enrollment_id = p_cert_prd_enrollment_id
1123: and cre.certification_id = crt.certification_id
1124: and cpe.cert_enrollment_id = cre.cert_enrollment_id;
1125:

Line 1228: from ota_certifications_b b

1224: , b.VALIDITY_START_TYPE
1225: , b.PUBLIC_FLAG
1226: , b.START_DATE_ACTIVE
1227: , b.END_DATE_ACTIVE
1228: from ota_certifications_b b
1229: where b.certification_id = p_certification_id;
1230:
1231: CURSOR csr_cert_mbr(p_certification_id in ota_cert_enrollments.certification_id%type) IS
1232: select

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

2091: RETURN null;
2092:
2093: End get_latest_cpe_col;
2094:
2095: function get_elapsed_due_date(p_certification_id ota_certifications_b.certification_id%type) return date is
2096: CURSOR csr_crt IS
2097: select
2098: b.certification_id certification_id
2099: , b.INITIAL_COMPLETION_DATE

Line 2103: from ota_certifications_b b

2099: , b.INITIAL_COMPLETION_DATE
2100: , b.VALIDITY_DURATION
2101: , b.VALIDITY_DURATION_UNITS
2102: , b.renewable_flag
2103: from ota_certifications_b b
2104: where b.certification_id = p_certification_id;
2105:
2106:
2107: l_proc VARCHAR2(72) := g_package||' get_elapsed_due_date';