DBA Data[Home] [Help]

APPS.OKE_DTS_INTEGRATION_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 686: FROM ORG_ORGANIZATION_DEFINITIONS

682: WHERE Inventory_Item_ID = P_ID;
683:
684: CURSOR OU_C ( P_Organization_ID NUMBER ) IS
685: SELECT OPERATING_UNIT
686: FROM ORG_ORGANIZATION_DEFINITIONS
687: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
688:
689: -- linfo l_line_csr%rowtype;
690: L_Flag VARCHAR2(1);

Line 1177: FROM gl_sets_of_books gl, org_organization_definitions org

1173: where organization_id = l_exp_org_id );
1174:
1175: CURSOR Curr_C ( P_ID NUMBER ) IS
1176: SELECT gl.Currency_Code
1177: FROM gl_sets_of_books gl, org_organization_definitions org
1178: WHERE org.organization_id = P_ID
1179: AND gl.Set_Of_Books_ID = org.Set_Of_Books_ID;
1180:
1181: CURSOR Header_C IS

Line 1463: , org_organization_definitions ood

1459: l_item_description
1460: from oke_k_deliverables_b d
1461: , okc_k_headers_b h
1462: , mtl_parameters mp
1463: , org_organization_definitions ood
1464: , oke_k_vers_numbers_v ver
1465: where d.deliverable_id = p_deliverable_id
1466: and h.id = d.k_header_id
1467: and ver.chr_id = d.k_header_id