APPS.OKE_DTS_WORKFLOW dependencies on HR_ALL_ORGANIZATION_UNITS

Line 91: FROM HR_ALL_ORGANIZATION_UNITS

87: P_API_VERSION NUMBER;
88:
89: CURSOR CSR_ORG(P_ORG_ID Number) IS
90: SELECT NAME
91: FROM HR_ALL_ORGANIZATION_UNITS
92: WHERE ORGANIZATION_ID = P_ORG_ID;
93:
94: CURSOR CSR_DTS(P_DELIVERABLE_ID IN NUMBER) IS
95: SELECT D.K_HEADER_ID

Line 1484: From hr_all_organization_units

1480: Wsh_Rec Wsh_C3%ROWTYPE;
1481:
1482: Cursor Org_C(P_Id Number) Is
1483: Select Name
1484: From hr_all_organization_units
1485: Where Organization_Id = P_Id;
1486:
1487: BEGIN
1488:

Line 1690: From hr_all_organization_units

1686: Mds_Rec Mds_C3%ROWTYPE;
1687:
1688: Cursor Org_C(P_Id Number) Is
1689: Select Name
1690: From hr_all_organization_units
1691: Where Organization_Id = P_Id;
1692:
1693: BEGIN
1694: L_Return_Status := Oke_Api.G_Ret_Sts_Success;

Line 1894: From hr_all_organization_units

1890: Po_Rec Po_C3%ROWTYPE;
1891:
1892: Cursor Org_C(P_Id Number) Is
1893: Select Name
1894: From hr_all_organization_units
1895: Where Organization_Id = P_Id;
1896:
1897: BEGIN
1898: L_Return_Status := Oke_Api.G_Ret_Sts_Success;