APPS.OE_VALUE_TO_ID dependencies on OKS_COVERAGE_TEMPLTS_V

Line 6985: from oks_coverage_templts_v

6981: RETURN NULL;
6982: END IF;
6983: select id
6984: into l_subs_template_id
6985: from oks_coverage_templts_v
6986: where item_type = 'SUBSCRIPTION'
6987: and name = p_service_subs_template
6988: and (sysdate between nvl(start_date, sysdate) and nvl(end_date, sysdate)) ;
6989: RETURN l_subs_template_id;

Line 7022: from oks_coverage_templts_v

7018: RETURN NULL;
7019: END IF;
7020: select id
7021: into l_cov_template_id
7022: from oks_coverage_templts_v
7023: where item_type = 'SERVICE'
7024: and name = p_service_cov_template
7025: and (sysdate between nvl(start_date, sysdate) and nvl(end_date, sysdate)) ;
7026: RETURN l_cov_template_id;