APPS.OTA_CRT_BUS dependencies on OTA_CERTIFICATION_MEMBERS

Line 967: FROM ota_certification_members m

963: ) IS
964: --
965: CURSOR csr_has_cmb is
966: SELECT 'Y'
967: FROM ota_certification_members m
968: where m.certification_id = p_cert_id;
969:
970: CURSOR csr_cmb_dates is
971: SELECT

Line 973: FROM ota_certification_members m

969:
970: CURSOR csr_cmb_dates is
971: SELECT
972: min(m.start_date_active) earliest_start, max(m.end_date_active) latest_end
973: FROM ota_certification_members m
974: WHERE m.certification_id = p_cert_id;
975:
976: l_proc VARCHAR2(72) := g_package|| 'chk_cmb_dates';
977: l_has_cmb varchar2(1);