APPS.PA_UTILS3 dependencies on HR_ALL_ORGANIZATION_UNITS_TL

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