DBA Data[Home] [Help]

APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on FND_RESPONSIBILITY

Line 255: l_resp_key fnd_responsibility.responsibility_key%type;

251: IS
252: l_url varchar2(4000);
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;

Line 256: l_resp_id fnd_responsibility.responsibility_id%type;

252: l_url varchar2(4000);
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: --

Line 271: FROM fnd_responsibility

267: --
268: CURSOR csr_get_resp_id (resp_key varchar2,apl_id number)
269: IS
270: SELECT responsibility_id
271: FROM fnd_responsibility
272: WHERE responsibility_key = resp_key
273: AND application_id = apl_id;
274: --
275: CURSOR csr_get_src_assignment