APPS.IRC_PENDING_DATA_API dependencies on FND_RESPONSIBILITY

Line 762: l_resp_key fnd_responsibility.responsibility_key%type;

758: --
759: l_proc varchar2(72) := g_package||'process_applications';
760:
761: l_person_id per_all_people_f.person_id%type;
762: l_resp_key fnd_responsibility.responsibility_key%type;
763: l_irc_resp_id fnd_responsibility.responsibility_id%type;
764: l_irc_resp_appl_id fnd_responsibility.application_id%type;
765: l_reg_bg_id number;
766:

Line 763: l_irc_resp_id fnd_responsibility.responsibility_id%type;

759: l_proc varchar2(72) := g_package||'process_applications';
760:
761: l_person_id per_all_people_f.person_id%type;
762: l_resp_key fnd_responsibility.responsibility_key%type;
763: l_irc_resp_id fnd_responsibility.responsibility_id%type;
764: l_irc_resp_appl_id fnd_responsibility.application_id%type;
765: l_reg_bg_id number;
766:
767: l_resume_file_name irc_pending_data.resume_file_name%type;

Line 764: l_irc_resp_appl_id fnd_responsibility.application_id%type;

760:
761: l_person_id per_all_people_f.person_id%type;
762: l_resp_key fnd_responsibility.responsibility_key%type;
763: l_irc_resp_id fnd_responsibility.responsibility_id%type;
764: l_irc_resp_appl_id fnd_responsibility.application_id%type;
765: l_reg_bg_id number;
766:
767: l_resume_file_name irc_pending_data.resume_file_name%type;
768: l_resume_description irc_pending_data.resume_description%type;

Line 819: from fnd_responsibility

815: where user_name= upper(p_user_name);
816: --
817: cursor csr_get_resp_id(p_resp_key varchar2) is
818: select responsibility_id,application_id
819: from fnd_responsibility
820: where responsibility_key = p_resp_key;
821: l_resp_id fnd_responsibility.responsibility_id%type;
822: l_appl_id fnd_responsibility.application_id%type;
823: --

Line 821: l_resp_id fnd_responsibility.responsibility_id%type;

817: cursor csr_get_resp_id(p_resp_key varchar2) is
818: select responsibility_id,application_id
819: from fnd_responsibility
820: where responsibility_key = p_resp_key;
821: l_resp_id fnd_responsibility.responsibility_id%type;
822: l_appl_id fnd_responsibility.application_id%type;
823: --
824: cursor csr_get_sg_id(p_sec_group_key varchar2) is
825: select security_group_id

Line 822: l_appl_id fnd_responsibility.application_id%type;

818: select responsibility_id,application_id
819: from fnd_responsibility
820: where responsibility_key = p_resp_key;
821: l_resp_id fnd_responsibility.responsibility_id%type;
822: l_appl_id fnd_responsibility.application_id%type;
823: --
824: cursor csr_get_sg_id(p_sec_group_key varchar2) is
825: select security_group_id
826: from fnd_security_groups