APPS.PER_ORG_MAN_COUNT_NAME_PKG dependencies on PER_ALL_PEOPLE_F

Line 26: PER_ALL_PEOPLE_F.E.FULL_NAME%type and

22: 20-JUN-97 70.7 LMA 1) Fixed bug 507611
23: NLSP16.1 FRM-40735 WHEN-VALIDATE-ITEM
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

Line 50: MANAGER_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;

46: PROCEDURE MANAGER_COUNT_NAME(P_ORGANIZATION_ID IN NUMBER,
47: P_BUSINESS_GROUP_ID IN NUMBER,
48: P_SESSION_DATE IN DATE,
49: P_MANAGER IN OUT NOCOPY VARCHAR2 ) IS
50: MANAGER_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;
51: NO_OF_MANAGERS NUMBER(4); --FIX FOR BUG 6219536
52: BEGIN
53: SELECT COUNT(DISTINCT E.PERSON_ID),
54: MAX(E.FULL_NAME)

Line 59: PER_ALL_PEOPLE_F E,

55: INTO
56: NO_OF_MANAGERS,
57: MANAGER_NAME
58: FROM
59: PER_ALL_PEOPLE_F E,
60: PER_ALL_ASSIGNMENTS_F A
61: WHERE (E.CURRENT_EMPLOYEE_FLAG = 'Y' OR
62: E.CURRENT_NPW_FLAG = 'Y')
63: AND A.PERSON_ID = E.PERSON_ID