APPS.ENG_DEFAULT_REVISED_ITEM dependencies on ENG_ENGINEERING_CHANGES

Line 30: FROM eng_engineering_changes

26: BEGIN
27:
28: SELECT status_type
29: INTO l_status_type
30: FROM eng_engineering_changes
31: WHERE change_notice = g_revised_item_rec.eco_name
32: AND organization_id = g_rev_item_unexp_rec.organization_id;
33:
34: RETURN l_status_type;

Line 1311: FROM eng_engineering_changes

1307: l_requestor NUMBER;
1308: BEGIN
1309: SELECT requestor_id
1310: INTO l_requestor
1311: FROM eng_engineering_changes
1312: WHERE change_notice = p_change_notice
1313: AND organization_id = p_organization_id;
1314:
1315: RETURN l_requestor;

Line 1374: FROM ENG_ENGINEERING_CHANGES

1370: WHERE els2.entity_name='ENG_CHANGE'
1371: AND els2.entity_id1 = cp_change_id
1372: AND els2.active_flag = 'Y'));
1373: CURSOR c_CheckApproval IS SELECT 1
1374: FROM ENG_ENGINEERING_CHANGES
1375: WHERE change_notice = p_revised_item_rec.eco_name
1376: AND organization_id =
1377: p_rev_item_unexp_rec.organization_id
1378: AND approval_status_type = 5;