APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 68: ,per_all_assignments_f asg

64: ,ipc.job_title as ipc_job_title
65: from irc_offers iof
66: ,per_all_vacancies vac
67: ,per_jobs_vl job
68: ,per_all_assignments_f asg
69: ,per_all_people_f ppf
70: ,irc_posting_contents_vl ipc
71: where
72: iof.offer_status = 'EXTENDED'

Line 101: ,per_all_assignments_f asg

97: ,iof.last_updated_by as last_updated
98: from irc_offers iof
99: ,per_all_vacancies vac
100: ,per_jobs_vl job
101: ,per_all_assignments_f asg
102: ,per_all_people_f ppf
103: ,irc_posting_contents_vl ipc
104: where
105: iof.offer_status = 'CLOSED'

Line 141: ,per_all_assignments_f asg

137: ,ipc.job_title as ipc_job_title
138: from irc_offers iof
139: ,per_all_vacancies vac
140: ,per_jobs_vl job
141: ,per_all_assignments_f asg
142: ,per_all_people_f ppf
143: ,irc_posting_contents_vl ipc
144: where
145: iof.offer_status = 'EXTENDED'

Line 175: ,per_all_assignments_f asg

171: ,ipc.job_title as ipc_job_title
172: from irc_offers iof
173: ,per_all_vacancies vac
174: ,per_jobs_vl job
175: ,per_all_assignments_f asg
176: ,per_all_people_f ppf
177: ,irc_posting_contents_vl ipc
178: where
179: iof.vacancy_id = vac.vacancy_id

Line 203: ,per_all_assignments_f asg

199: ,ppf.full_name as applicant_name
200: from irc_offers iof
201: ,per_all_vacancies vac
202: ,per_jobs_vl job
203: ,per_all_assignments_f asg
204: ,per_all_people_f ppf
205: where
206: iof.offer_status = 'HOLD'
207: and iof.vacancy_id = vac.vacancy_id

Line 258: l_apl_asg_id per_all_assignments_f.assignment_id%type;

254: --
255: l_resp_key fnd_responsibility.responsibility_key%type;
256: l_resp_id fnd_responsibility.responsibility_id%type;
257: l_apl_id fnd_application.application_id%type;
258: l_apl_asg_id per_all_assignments_f.assignment_id%type;
259: l_function_name fnd_profile_option_values.profile_option_value%type;
260: --
261: --
262: CURSOR csr_get_apl_id (apl_short_name varchar2)

Line 346: l_apl_asg_id per_all_assignments_f.assignment_id%type;

342: l_url varchar2(4000);
343: l_apps_fwk_agent varchar2(2000);
344: l_params varchar2(32767);
345: l_funcId number;
346: l_apl_asg_id per_all_assignments_f.assignment_id%type;
347: BEGIN
348: l_apl_asg_id := p_apl_asg_id;
349: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
350: ||fnd_profile.value('ICX_PREFIX'),'/');