APPS.PER_ORG_MAN_COUNT_NAME_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 28: HR_ALL_ORGANIZATION_UNITS.NAME%type

24: TRIGGER RAISED UNHANDLED EXCEPTION VALUE_E
25: by change MANAGER_NAME from varchar2(60) to
26: PER_ALL_PEOPLE_F.E.FULL_NAME%type and
27: ORGANIZATION_NAME from varchar2(60) to
28: HR_ALL_ORGANIZATION_UNITS.NAME%type
29: 2) Fixed hard coded messages
30: 24-Jun-97 70.8 teyres Changed as to is on create or replace line
31: 25-Jun-97 110.1/70.9 teyres 110.1 and 70.9 are the same
32: 03-DEC-97 110.2 mbocutt Add missing token substitution in message

Line 103: ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS.NAME%type;

99: P_VERSION_ID IN NUMBER,
100: P_USER_PERSON_TYPE OUT NOCOPY VARCHAR2) IS
101: --
102: NO_OF_ORGS NUMBER(3);
103: ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS.NAME%type;
104: MANAGER_FLAG_DESC VARCHAR2(80);
105: MANAGER_FLAG VARCHAR2(30);
106: --
107: BEGIN

Line 118: HR_ALL_ORGANIZATION_UNITS O,

114: ORGANIZATION_NAME,
115: MANAGER_FLAG_DESC,
116: MANAGER_FLAG
117: FROM PER_ALL_ASSIGNMENTS_F A,
118: HR_ALL_ORGANIZATION_UNITS O,
119: HR_ALL_ORGANIZATION_UNITS_TL OTL,
120: FND_LOOKUPS L
121: WHERE A.PERSON_ID = P_PERSON_ID
122: AND (A.ASSIGNMENT_TYPE = 'E' OR A.ASSIGNMENT_TYPE = 'C')

Line 119: HR_ALL_ORGANIZATION_UNITS_TL OTL,

115: MANAGER_FLAG_DESC,
116: MANAGER_FLAG
117: FROM PER_ALL_ASSIGNMENTS_F A,
118: HR_ALL_ORGANIZATION_UNITS O,
119: HR_ALL_ORGANIZATION_UNITS_TL OTL,
120: FND_LOOKUPS L
121: WHERE A.PERSON_ID = P_PERSON_ID
122: AND (A.ASSIGNMENT_TYPE = 'E' OR A.ASSIGNMENT_TYPE = 'C')
123: AND P_SESSION_DATE BETWEEN