APPS.OTA_CERT_PRD_ENROLLMENT_API dependencies on OTA_CERT_ENROLLMENTS

Line 284: ota_cert_enrollments cre

280: , b.END_DATE_ACTIVE
281: , cre.earliest_enroll_date
282: , cre.expiration_date
283: from ota_certifications_b b,
284: ota_cert_enrollments cre
285: where b.certification_id = cre.certification_id
286: and cre.cert_enrollment_id = p_cert_enrollment_id;
287:
288: CURSOR csr_cert_enrl IS

Line 297: FROM ota_cert_enrollments

293: completion_date,
294: is_history_flag,
295: person_id,
296: earliest_enroll_date
297: FROM ota_cert_enrollments
298: where cert_enrollment_id = p_cert_enrollment_id;
299:
300: CURSOR csr_max_cpe_exp_dt IS
301: select

Line 304: ota_cert_enrollments cre

300: CURSOR csr_max_cpe_exp_dt IS
301: select
302: max(cpe.expiration_date)
303: from ota_cert_prd_enrollments cpe,
304: ota_cert_enrollments cre
305: where cpe.cert_enrollment_id = cre.cert_enrollment_id
306: and cre.cert_enrollment_id = p_cert_enrollment_id;
307:
308: CURSOR csr_old_cpe_exp_dt IS

Line 322: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;

318:
319: rec_crt csr_crt%rowtype;
320: l_cert_enrl_rec csr_cert_enrl%ROWTYPE;
321:
322: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
323: l_expiration_date ota_cert_enrollments.expiration_date%type;
324: l_max_expiration_date date;
325: l_update_cre_dates_flag varchar2(1) := 'N';
326: l_cert_period_start_date date :=p_cert_period_start_date;

Line 323: l_expiration_date ota_cert_enrollments.expiration_date%type;

319: rec_crt csr_crt%rowtype;
320: l_cert_enrl_rec csr_cert_enrl%ROWTYPE;
321:
322: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
323: l_expiration_date ota_cert_enrollments.expiration_date%type;
324: l_max_expiration_date date;
325: l_update_cre_dates_flag varchar2(1) := 'N';
326: l_cert_period_start_date date :=p_cert_period_start_date;
327: l_cert_period_end_date date :=p_cert_period_end_date;

Line 774: ota_cert_enrollments cre

770: , b.PUBLIC_FLAG
771: , b.START_DATE_ACTIVE
772: , b.END_DATE_ACTIVE
773: from ota_certifications_b b,
774: ota_cert_enrollments cre
775: where cre.certification_id = b.certification_id
776: and cre.cert_enrollment_id = p_cert_enrollment_id;
777:
778:

Line 786: FROM ota_cert_enrollments

782: business_group_id,
783: certification_status_code,
784: object_version_number,
785: completion_date
786: FROM ota_cert_enrollments
787: where cert_enrollment_id = p_cert_enrollment_id;
788:
789: l_proc varchar2(72) := g_package || ' renew_cert_prd_enrollment';
790:

Line 794: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%type;

790:
791: rec_crt csr_crt%rowtype;
792: l_cert_enrl_rec csr_cert_enrl%ROWTYPE;
793:
794: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%type;
795: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
796:
797: p_effective_date DATE;
798: p_business_group_id DATE;

Line 802: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;

798: p_business_group_id DATE;
799:
800: l_certification_status_code VARCHAR2(30);
801:
802: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
803: l_expiration_date ota_cert_enrollments.expiration_date%type;
804:
805: p_expiration_date date;
806:

Line 803: l_expiration_date ota_cert_enrollments.expiration_date%type;

799:
800: l_certification_status_code VARCHAR2(30);
801:
802: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
803: l_expiration_date ota_cert_enrollments.expiration_date%type;
804:
805: p_expiration_date date;
806:
807: