APPS.INV_CONSIGN_NOTIF_UTL dependencies on PER_ALL_PEOPLE_F

Line 79: l_agent_name per_all_people_f.full_name%TYPE;

75: l_activity_name VARCHAR2(18) := 'CONSIGN_DIAG_NOTIF';
76: l_item_key_prefix VARCHAR2(17) := 'CONSIGN_DIAG_NTF_';
77: l_item_key_s NUMBER;
78: l_item_key VARCHAR2(240);
79: l_agent_name per_all_people_f.full_name%TYPE;
80:
81: BEGIN
82:
83: IF g_fnd_debug = 'Y' THEN

Line 101: FROM per_all_people_f

97:
98:
99: SELECT full_name
100: INTO l_agent_name
101: FROM per_all_people_f
102: WHERE person_id = p_agent_id
103: AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;
104:
105: IF g_fnd_debug = 'Y' THEN