APPS.ENG_ATTACHMENT_IMPLEMENTATION dependencies on ENG_ENGINEERING_CHANGES

Line 487: from eng_engineering_changes

483: IS
484:
485: cursor c_get_change_project_info IS
486: select project_id, task_id, organization_id
487: from eng_engineering_changes
488: where change_id = p_change_id;
489:
490: cursor c_get_curr_oper_unit_id(p_orgid NUMBER) IS
491: SELECT OPERATING_UNIT

Line 529: FROM eng_engineering_changes eec,eng_change_order_types ecot

525: END IF ;
526:
527: -- Execute following only for attachment approval
528: SELECT ecot.base_change_mgmt_type_code INTO l_base_change_mgmt_type_code
529: FROM eng_engineering_changes eec,eng_change_order_types ecot
530: WHERE eec.change_id = p_change_id
531: AND ecot.change_order_type_id = eec.change_order_type_id;
532:
533: -- insert into swarb values(8, 'change orde type', l_base_change_mgmt_type_code);

Line 1221: from eng_engineering_changes

1217: l_change_order_type_id number;
1218: l_base_change_mgmt_type_code varchar2(30);
1219: BEGIN
1220: select change_order_type_id into l_change_order_type_id
1221: from eng_engineering_changes
1222: where change_id = p_change_id;
1223: select base_change_mgmt_type_code into l_base_change_mgmt_type_code
1224: from eng_change_order_types
1225: where change_order_type_id = l_change_order_type_id;