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 48: MANAGER_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;

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

Line 57: PER_ALL_PEOPLE_F E,

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