APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on FND_APPLICATION

Line 257: l_apl_id fnd_application.application_id%type;

253: l_apps_fwk_agent varchar2(2000);
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: --

Line 265: from fnd_application

261: --
262: CURSOR csr_get_apl_id (apl_short_name varchar2)
263: IS
264: select application_id
265: from fnd_application
266: where application_short_name = apl_short_name;
267: --
268: CURSOR csr_get_resp_id (resp_key varchar2,apl_id number)
269: IS