APPS.EGO_IMPORT_BATCHES_PKG dependencies on ENG_ENGINEERING_CHANGES

Line 513: FROM eng_engineering_changes eec,

509:
510: Cursor Change_Order_Notice_Csr(v_change_mgmt_type_code IN VARCHAR2, v_change_notice IN VARCHAR2, v_master_org_id IN NUMBER) IS
511: SELECT change_notice
512: FROM (SELECT DISTINCT eec.change_notice, eec.CHANGE_MGMT_TYPE_CODE
513: FROM eng_engineering_changes eec,
514: eng_lifecycle_statuses els,
515: eng_change_statuses_vl ecs
516: WHERE els.entity_name(+) = 'ENG_CHANGE'
517: AND els.entity_id1(+) = eec.change_id

Line 537: FROM ENG_ENGINEERING_CHANGES EEC1, MTL_PARAMETERS mtp

533: (eec.approval_status_type = 3 AND
534: els.change_editable_flag = 'Y')))) QRSLT
535: WHERE (CHANGE_NOTICE IN
536: (SELECT CHANGE_NOTICE
537: FROM ENG_ENGINEERING_CHANGES EEC1, MTL_PARAMETERS mtp
538: WHERE EEC1.ORGANIZATION_ID = mtp.ORGANIZATION_ID
539: and mtp.MASTER_ORGANIZATION_ID = v_master_org_id) AND
540: (UPPER(CHANGE_MGMT_TYPE_CODE) =
541: UPPER(v_change_mgmt_type_code)))