APPS.ENG_CHANGE_ADMIN_UTIL dependencies on ENG_ENGINEERING_CHANGES

Line 14: from eng_engineering_changes

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
17: select 1 from eng_change_type_reasons
18: where reason_code = p_reason_code

Line 37: from eng_engineering_changes

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
40: SELECT 1
41: FROM ENG_CHANGE_TYPE_PRIORITIES

Line 72: from eng_engineering_changes eec

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;
75: return (delete_flag);
76:

Line 94: from eng_engineering_changes

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);
97:
98: return (delete_flag);

Line 121: from eng_engineering_changes eec

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
124: exists (select 1
125: from eng_change_type_class_codes ectcc