APPS.OE_VALIDATE dependencies on OKS_COVERAGE_TEMPLTS_V

Line 10449: from oks_coverage_templts_v

10445: RETURN TRUE;
10446: END IF;
10447: select 'Y'
10448: INTO l_exists
10449: from oks_coverage_templts_v
10450: where item_type = 'SUBSCRIPTION'
10451: AND id = p_service_subs_template_id
10452: and (sysdate between nvl(start_date, sysdate)
10453: and nvl(end_date, sysdate));

Line 10528: from oks_coverage_templts_v

10524: RETURN TRUE;
10525: END IF;
10526: select 'Y'
10527: INTO l_exists
10528: from oks_coverage_templts_v
10529: where item_type = 'SERVICE' AND id =p_service_cov_template_id
10530: and (sysdate between nvl(start_date, sysdate) and nvl(end_date, sysdate));
10531: RETURN TRUE;
10532: EXCEPTION