DBA Data[Home] [Help]

APPS.ENG_CHANGE_ADMIN_UTIL dependencies on DUAL

Line 12: from dual

8:
9: BEGIN
10: select 2
11: into delete_flag
12: from dual
13: where exists (select 1
14: from eng_engineering_changes
15: where reason_code = p_reason_Code
16: union all

Line 35: from dual

31:
32: BEGIN
33: select 2
34: into delete_flag
35: from dual
36: where exists (select 1
37: from eng_engineering_changes
38: where priority_code = p_priority_code
39: UNION ALL

Line 70: from dual

66: -- seeded status
67: IF delete_flag <> 2 then
68: select 2
69: into delete_flag
70: from dual
71: where exists (select 1
72: from eng_engineering_changes eec
73: where eec.status_type = p_status_code);
74: END IF;

Line 92: from dual

88:
89: BEGIN
90: select 2
91: into delete_flag
92: from dual
93: where exists (select 1
94: from eng_engineering_changes
95: where status_Code = p_status_Code
96: and change_order_type_id =p_change_type_id);

Line 119: from dual

115: -- Check for Changes/Types Existent for this classifaction _id
116:
117: select 2
118: into delete_flag
119: from dual
120: where exists (select 1
121: from eng_engineering_changes eec
122: where eec.classification_id = p_classification_id )
123: or