DBA Data[Home] [Help]

APPS.OE_ID_TO_VALUE dependencies on OKS_COVERAGE_TEMPLTS_V

Line 7250: from oks_coverage_templts_v

7246: BEGIN
7247: IF p_service_subs_template_id IS NOT NULL THEN
7248: select name
7249: into l_Subscription_Template
7250: from oks_coverage_templts_v
7251: where item_type = 'SUBSCRIPTION'
7252: and id = p_service_subs_template_id ;
7253: ELSE
7254: l_Subscription_Template:= NULL;

Line 7286: from oks_coverage_templts_v

7282: BEGIN
7283: IF p_service_cov_template_id IS NOT NULL THEN
7284: select name
7285: into l_Coverage_Template
7286: from oks_coverage_templts_v
7287: where item_type = 'SERVICE'
7288: and id = p_service_cov_template_id ;
7289: ELSE
7290: l_Coverage_Template:= NULL;