APPS.OTA_CRT_BUS dependencies on OTA_CERT_ENROLLMENTS

Line 868: -- ota_cert_enrollments exist.

864: -- PUBLIC
865: -- Description:
866: -- Delete Validation.
867: -- This certification may not be deleted if child rows in
868: -- ota_cert_enrollments exist.
869: --
870: Procedure chk_enr_exists
871: (
872: p_certification_id in number

Line 880: from ota_cert_enrollments cre

876: l_proc varchar2(72) := g_package||'chk_enr_exists';
877: --
878: cursor sel_enr_exists is
879: select 'Y'
880: from ota_cert_enrollments cre
881: where cre.certification_id = p_certification_id;
882: --
883: Begin
884:

Line 930: from ota_cert_enrollments cre

926: hr_utility.set_location('Entering:'|| l_proc, 10);
927:
928: select min(cre.enrollment_date), max(cre.enrollment_date)
929: into l_min_date, l_max_date
930: from ota_cert_enrollments cre
931: where cre.certification_id = p_certification_id;
932:
933: if ((l_min_date is not null and l_min_date < p_start_date_active)
934: or (l_max_date is not null and p_end_date_active is not null and l_max_date > p_end_date_active))

Line 1049: FROM OTA_CERT_ENROLLMENTS

1045:
1046: CURSOR csr_exis_subscr
1047: IS
1048: SELECT 'Y'
1049: FROM OTA_CERT_ENROLLMENTS
1050: where certification_id = p_certification_id;
1051:
1052: l_subscr_exists varchar2(1);
1053: