APPS.EGO_IMPORT_BATCHES_PKG dependencies on ENG_CHANGE_ORDER_TYPES_V

Line 487: from eng_change_order_types_vl

483: decode(sign(nvl(disable_date, sysdate + 1) - sysdate),
484: 1,
485: 'N',
486: 'Y') DISABLE_FLAG
487: from eng_change_order_types_vl
488: where base_change_mgmt_type_code = v_change_mgmt_type_code
489: and type_classification = 'CATEGORY';
490:
491: Cursor Change_Order_Type_Csr(v_change_mgmt_type_code IN VARCHAR2, v_change_order_type_id IN NUMBER) IS

Line 499: from eng_change_order_types_v

495: change_order_type_id,
496: change_mgmt_type_code,
497: assembly_type,
498: subject_id
499: from eng_change_order_types_v
500: where (disable_date is null or disable_date >= sysdate)
501: and nvl(START_DATE, sysdate) <= sysdate
502: and type_classification = 'HEADER'
503: and NOT (nvl(FND_PROFILE.value('ENG:ENG_ITEM_ECN_ACCESS'), 1) = 2 and