APPS.EGO_ODI_PUB dependencies on MTL_PARAMETERS

Line 267: from mtl_parameters

263:
264: --dbms_output.put_line(' with org id :'||p_org_id );
265: select organization_id
266: INTO x_organization_id
267: from mtl_parameters
268: WHERE organization_id = to_number(l_org_id);
269:
270: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
271: p_odi_session_id => p_odi_session_id,

Line 281: from mtl_parameters

277:
278: --dbms_output.put_line(' with org code p_org_code: '|| p_org_code);
279: select organization_id
280: INTO x_organization_id
281: from mtl_parameters
282: WHERE organization_code = p_org_code;
283:
284: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
285: p_odi_session_id => p_odi_session_id,

Line 5353: FROM ego_pub_ws_flat_recs, mtl_parameters

5349: CURSOR c_master_recs_first(cp_session_id NUMBER)
5350: IS
5351: SELECT SEQUENCE_ID,
5352: decode(organization_id,master_organization_id,0,1) as master_or_child
5353: FROM ego_pub_ws_flat_recs, mtl_parameters
5354: WHERE session_id = cp_session_id
5355: AND entity_type = 'ITEM'
5356: AND NVL (parent_sequence_id, -1) = -1
5357: AND pk2_value = organization_id