APPS.JTF_RS_IMPORT_USER_PUB dependencies on JTF_IAPP_FAMILIES_B

Line 79: cursor c_nav_resp_group (l_app_family_id jtf_iapp_families_b.app_family_id%type,

75: select responsibility_id
76: from fnd_responsibility_vl
77: where responsibility_name = l_resp_group;
78:
79: cursor c_nav_resp_group (l_app_family_id jtf_iapp_families_b.app_family_id%type,
80: l_responsibility_id fnd_responsibility.responsibility_id%type) is
81: select 1 from jtf_iapp_families_b jif, fnd_responsibility fr,
82: jtf_iapp_family_app_map jpm
83: where jif.app_family_id = jpm.app_family_id

Line 81: select 1 from jtf_iapp_families_b jif, fnd_responsibility fr,

77: where responsibility_name = l_resp_group;
78:
79: cursor c_nav_resp_group (l_app_family_id jtf_iapp_families_b.app_family_id%type,
80: l_responsibility_id fnd_responsibility.responsibility_id%type) is
81: select 1 from jtf_iapp_families_b jif, fnd_responsibility fr,
82: jtf_iapp_family_app_map jpm
83: where jif.app_family_id = jpm.app_family_id
84: and jpm.application_id = fr.application_id
85: and fr.responsibility_id = l_responsibility_id

Line 122: l_app_family_id1 jtf_iapp_families_b.app_family_id%type;

118: l_role_id2 jtf_rs_roles_b.role_id%type;
119: l_role_code1 jtf_rs_roles_b.role_code%type;
120: l_role_code2 jtf_rs_roles_b.role_code%type;
121:
122: l_app_family_id1 jtf_iapp_families_b.app_family_id%type;
123: l_app_family_id2 jtf_iapp_families_b.app_family_id%type;
124: l_responsibility_id1 fnd_responsibility.responsibility_id%type;
125: l_responsibility_id2 fnd_responsibility.responsibility_id%type;
126:

Line 123: l_app_family_id2 jtf_iapp_families_b.app_family_id%type;

119: l_role_code1 jtf_rs_roles_b.role_code%type;
120: l_role_code2 jtf_rs_roles_b.role_code%type;
121:
122: l_app_family_id1 jtf_iapp_families_b.app_family_id%type;
123: l_app_family_id2 jtf_iapp_families_b.app_family_id%type;
124: l_responsibility_id1 fnd_responsibility.responsibility_id%type;
125: l_responsibility_id2 fnd_responsibility.responsibility_id%type;
126:
127: l_num number;