APPS.OTA_COMPETENCE_SS dependencies on OTA_CERT_ENROLLMENTS

Line 1949: l_expiry_date ota_cert_enrollments.expiration_date%type;

1945: l_rightpos NUMBER ;
1946: l_count NUMBER := 1;
1947: l_learning_path_ids VARCHAR2(4000);
1948: l_eff_date_from varchar2(4000);
1949: l_expiry_date ota_cert_enrollments.expiration_date%type;
1950: l_eff_date_to varchar2(4000):=NULL;
1951:
1952: l_comp_id NUMBER;
1953: l_renewable_period_frequency NUMBER;

Line 2017: from ota_cert_enrollments cenr

2013: AND trunc(sysdate) between pc.DATE_FROM and nvl(pc.DATE_TO,(sysdate+1));
2014:
2015: Cursor get_cert_expiry is
2016: select cenr.expiration_date
2017: from ota_cert_enrollments cenr
2018: where certification_id = p_certification_id
2019: and person_id = p_person_id;
2020: -- and certification_status_code ='CERTIFIED';--not ok?//////////////
2021: