APPS.PA_UTILS3 dependencies on HR_ALL_ORGANIZATION_UNITS

Line 284: Hr_All_Organization_Units O

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

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

576: Org ID passedas a input parameter.
577: Arguments : P_Org_ID - Organization Identifier
578: Return : Operating Unit Name
579: ***************************************************************************/
580: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
581: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE IS
582: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
583:
584: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS

Line 581: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE IS

577: Arguments : P_Org_ID - Organization Identifier
578: Return : Operating Unit Name
579: ***************************************************************************/
580: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
581: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE IS
582: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
583:
584: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
585: SELECT Name

Line 582: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

578: Return : Operating Unit Name
579: ***************************************************************************/
580: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
581: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE IS
582: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
583:
584: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
585: SELECT Name
586: FROM HR_ALL_ORGANIZATION_UNITS_TL

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

580: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
581: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE IS
582: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
583:
584: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
585: SELECT Name
586: FROM HR_ALL_ORGANIZATION_UNITS_TL
587: WHERE Organization_ID = P_Org_ID
588: AND Language = USERENV('LANG');

Line 586: FROM HR_ALL_ORGANIZATION_UNITS_TL

582: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
583:
584: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
585: SELECT Name
586: FROM HR_ALL_ORGANIZATION_UNITS_TL
587: WHERE Organization_ID = P_Org_ID
588: AND Language = USERENV('LANG');
589: BEGIN
590: IF G_OUName_Tab.COUNT > 0 THEN