DBA Data[Home] [Help]

APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on FND_RESPONSIBILITY

Line 708: FROM fnd_responsibility

704: IS
705: CURSOR csr_get_resp_id (resp_key varchar2)
706: IS
707: SELECT responsibility_id
708: FROM fnd_responsibility
709: WHERE responsibility_key = resp_key;
710:
711: l_resp_key fnd_responsibility.responsibility_key%type;
712: l_resp_id fnd_responsibility.responsibility_id%type;

Line 711: l_resp_key fnd_responsibility.responsibility_key%type;

707: SELECT responsibility_id
708: FROM fnd_responsibility
709: WHERE responsibility_key = resp_key;
710:
711: l_resp_key fnd_responsibility.responsibility_key%type;
712: l_resp_id fnd_responsibility.responsibility_id%type;
713: l_function_name fnd_profile_option_values.profile_option_value%type;
714: BEGIN
715:

Line 712: l_resp_id fnd_responsibility.responsibility_id%type;

708: FROM fnd_responsibility
709: WHERE responsibility_key = resp_key;
710:
711: l_resp_key fnd_responsibility.responsibility_key%type;
712: l_resp_id fnd_responsibility.responsibility_id%type;
713: l_function_name fnd_profile_option_values.profile_option_value%type;
714: BEGIN
715:
716: if(lower(p_is_internal) = 'y')