APPS.PA_UTILS3 dependencies on HR_ALL_ORGANIZATION_UNITS

Line 285: Hr_All_Organization_Units O

281: Into
282: X_Inc_By_Org_Name
283: From
284: Per_Assignments_F A,
285: Hr_All_Organization_Units O
286: Where
287: O.Organization_id = A.Organization_Id
288: And A.person_id = P_Inc_By_Per_Id
289: And A.Primary_Flag = 'Y'

Line 625: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)

621: Org ID passedas a input parameter.
622: Arguments : P_Org_ID - Organization Identifier
623: Return : Operating Unit Name
624: ***************************************************************************/
625: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
626: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE IS
627: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
628:
629: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS

Line 626: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE IS

622: Arguments : P_Org_ID - Organization Identifier
623: Return : Operating Unit Name
624: ***************************************************************************/
625: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
626: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE IS
627: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
628:
629: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
630: SELECT Name

Line 627: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

623: Return : Operating Unit Name
624: ***************************************************************************/
625: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
626: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE IS
627: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
628:
629: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
630: SELECT Name
631: FROM HR_ALL_ORGANIZATION_UNITS_TL

Line 629: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS

625: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
626: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE IS
627: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
628:
629: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
630: SELECT Name
631: FROM HR_ALL_ORGANIZATION_UNITS_TL
632: WHERE Organization_ID = P_Org_ID
633: AND Language = USERENV('LANG');

Line 631: FROM HR_ALL_ORGANIZATION_UNITS_TL

627: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
628:
629: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
630: SELECT Name
631: FROM HR_ALL_ORGANIZATION_UNITS_TL
632: WHERE Organization_ID = P_Org_ID
633: AND Language = USERENV('LANG');
634: BEGIN
635: IF G_OUName_Tab.COUNT > 0 THEN