DBA Data[Home] [Help]

APPS.OKE_DTS_INTEGRATION_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 688: FROM ORG_ORGANIZATION_DEFINITIONS

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

Line 1215: FROM gl_sets_of_books gl, org_organization_definitions org

1211: where organization_id = l_exp_org_id );
1212:
1213: CURSOR Curr_C ( P_ID NUMBER ) IS
1214: SELECT gl.Currency_Code
1215: FROM gl_sets_of_books gl, org_organization_definitions org
1216: WHERE org.organization_id = P_ID
1217: AND gl.Set_Of_Books_ID = org.Set_Of_Books_ID;
1218:
1219: CURSOR Header_C IS

Line 1506: , org_organization_definitions ood

1502: l_item_description
1503: from oke_k_deliverables_b d
1504: , okc_k_headers_b h
1505: , mtl_parameters mp
1506: , org_organization_definitions ood
1507: , oke_k_vers_numbers_v ver
1508: where d.deliverable_id = p_deliverable_id
1509: and h.id = d.k_header_id
1510: and ver.chr_id = d.k_header_id