DBA Data[Home] [Help]

APPS.OKC_KSQ_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2371: FROM HR_ALL_ORGANIZATION_UNITS

2367: l_opu Number ;
2368:
2369: CURSOR BUSINESS_GROUP_CSR(V_ORG_ID NUMBER) IS
2370: SELECT BUSINESS_GROUP_ID
2371: FROM HR_ALL_ORGANIZATION_UNITS
2372: WHERE ORGANIZATION_ID = V_ORG_ID;
2373: --end npalepu
2374:
2375: l_cls_code okc_subclasses_b.cls_code%TYPE;

Line 2656: FROM HR_ALL_ORGANIZATION_UNITS

2652: l_opu Number ;
2653:
2654: CURSOR BUSINESS_GROUP_CSR(V_ORG_ID NUMBER) IS
2655: SELECT BUSINESS_GROUP_ID
2656: FROM HR_ALL_ORGANIZATION_UNITS
2657: WHERE ORGANIZATION_ID = V_ORG_ID;
2658: --END NPALEPU
2659:
2660: Function Contract_Is_Unique(p_contract_number IN