APPS.IRC_CREATE_NOTIFICATION_PKG dependencies on PER_ALL_PEOPLE_F

Line 28: l_party_id per_all_people_f.party_id%TYPE := null;

24: l_table_owner varchar2(30);
25: l_status varchar2(255);
26: l_industry varchar2(255);
27: l_dummy boolean;
28: l_party_id per_all_people_f.party_id%TYPE := null;
29: --
30: --
31: type person_id_t is table of per_all_assignments_f.person_id%type index by binary_integer;
32: l_person_ids person_id_t;

Line 34: type party_id_t is table of per_all_people_f.party_id%TYPE index by binary_integer;

30: --
31: type person_id_t is table of per_all_assignments_f.person_id%type index by binary_integer;
32: l_person_ids person_id_t;
33: --
34: type party_id_t is table of per_all_people_f.party_id%TYPE index by binary_integer;
35: l_party_ids party_id_t;
36: --
37: type l_rowid_type is table of rowid index by binary_integer;
38: l_rowid l_rowid_type;

Line 56: FROM per_all_people_f ppf1

52: SELECT /*+ ROWID(ppf1) */
53: ppf1.person_id person_id
54: ,ppf1.rowid
55: ,ppf1.party_id party_id
56: FROM per_all_people_f ppf1
57: WHERE trunc(sysdate) between ppf1.effective_start_date and ppf1.effective_end_date
58: AND ppf1.rowid BETWEEN start_rowid and end_rowid
59: AND person_id = (select min(person_id)
60: from per_all_assignments_f paaf

Line 64: from per_all_people_f ppf

60: from per_all_assignments_f paaf
61: where paaf.assignment_type = 'A'
62: and trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
63: and person_id in (select ppf.person_id
64: from per_all_people_f ppf
65: where ppf.party_id = ppf1.party_id
66: and trunc(sysdate) between ppf.effective_start_date
67: and ppf.effective_end_date
68: AND NOT EXISTS ( SELECT /*+ no_unnest */ 1

Line 70: ,per_all_people_f ppf2

66: and trunc(sysdate) between ppf.effective_start_date
67: and ppf.effective_end_date
68: AND NOT EXISTS ( SELECT /*+ no_unnest */ 1
69: FROM irc_notification_preferences inp
70: ,per_all_people_f ppf2
71: WHERE ppf.party_id = ppf2.party_id
72: AND ppf2.person_id = inp.person_id
73: AND trunc(sysdate) between ppf2.effective_start_date
74: and ppf2.effective_end_date

Line 83: l_table_name := 'PER_ALL_PEOPLE_F';

79:
80: --
81: begin
82: --
83: l_table_name := 'PER_ALL_PEOPLE_F';
84: l_dummy:=fnd_installation.get_app_info(
85: application_short_name=>'PER'
86: ,status =>l_status
87: ,industry =>l_industry