APPS.OTA_COMPETENCE_SS dependencies on OTA_CERT_ENROLLMENTS

Line 1928: l_expiry_date ota_cert_enrollments.expiration_date%type;

1924: l_rightpos NUMBER ;
1925: l_count NUMBER := 1;
1926: l_learning_path_ids VARCHAR2(4000);
1927: l_eff_date_from varchar2(4000);
1928: l_expiry_date ota_cert_enrollments.expiration_date%type;
1929: l_eff_date_to varchar2(4000);
1930:
1931: l_proc varchar2(72) := g_package||'COMP_RETREIVE';
1932:

Line 1959: from ota_cert_enrollments cenr

1955: AND pce.object_id = p_certification_id;
1956:
1957: Cursor get_cert_expiry is
1958: select cenr.expiration_date
1959: from ota_cert_enrollments cenr
1960: where certification_id = p_certification_id
1961: and person_id = p_person_id;
1962: -- and certification_status_code ='CERTIFIED';--not ok?//////////////
1963: