DBA Data[Home] [Help]

APPS.BOM_DIAGUNITTEST_ECODATA dependencies on DUAL

Line 97: from dual

93:
94: /* Verify if the input corresponds to an existing Eco */
95: Begin
96: Select 1 into l_eco_exists
97: from dual
98: where exists (select 1
99: from eng_engineering_changes
100: where change_notice=l_eco_name
101: and organization_id=nvl(l_org_id,organization_id));

Line 112: from dual

108:
109: /* Verify if the input corresponds to an existing MCO (Mass Change Order) */
110: Begin
111: Select 1 into l_mco_exists
112: from dual
113: where exists (select 1
114: from eng_eng_changes_interface
115: where change_notice=l_eco_name
116: and organization_id=nvl(l_org_id,organization_id));