APPS.PA_CI_ACTIONS_UTIL dependencies on PER_ALL_PEOPLE_F

Line 71: from per_all_people_f pap,

67:
68: -- Modified the cursor definiton for bug#4068669.
69: Cursor internal is
70: select pap.party_id
71: from per_all_people_f pap,
72: fnd_user fu
73: where fu.user_id = p_user_id
74: and fu.employee_id = pap.person_id
75: and trunc(sysdate) between trunc(pap.effective_start_date) and trunc(pap.effective_end_date) ;

Line 125: from per_all_people_f p

121:
122: -- Modified the cursor defintion for bug#4068669.
123: Cursor C1 IS
124: select party_id
125: from per_all_people_f p
126: where p.person_id = l_resource_id
127: and trunc(p_date) between trunc(p.effective_start_date) and trunc(p.effective_end_date);
128: --select party_id from hz_parties
129: --where orig_system_reference = 'PER:'||TO_CHAR(l_resource_id);