APPS.JTF_RS_IMPORT_USER_PUB dependencies on JTF_RS_ROLES_VL

Line 32: l_res_role1 jtf_rs_roles_vl.role_name%type;

28: l_mgr_user_name jtf_rs_resource_extns.user_name%type ;
29:
30: l_nav_group1 jtf_iapp_families_vl.app_family_display_name%type;
31: l_resp_group1 fnd_responsibility_vl.responsibility_name%type;
32: l_res_role1 jtf_rs_roles_vl.role_name%type;
33:
34: l_nav_group2 jtf_iapp_families_vl.app_family_display_name%type;
35: l_resp_group2 fnd_responsibility_vl.responsibility_name%type;
36: l_res_role2 jtf_rs_roles_vl.role_name%type;

Line 36: l_res_role2 jtf_rs_roles_vl.role_name%type;

32: l_res_role1 jtf_rs_roles_vl.role_name%type;
33:
34: l_nav_group2 jtf_iapp_families_vl.app_family_display_name%type;
35: l_resp_group2 fnd_responsibility_vl.responsibility_name%type;
36: l_res_role2 jtf_rs_roles_vl.role_name%type;
37:
38: l_employee_number per_all_people_f.employee_number%type ;
39: l_resource_group jtf_rs_groups_vl.group_name%type ;
40: l_default_resp fnd_responsibility_vl.responsibility_name%type ;

Line 98: cursor c_res_role (l_role_name jtf_rs_roles_vl.role_name%type) is

94: select group_id
95: from jtf_rs_groups_vl
96: where group_name = l_resource_group;
97:
98: cursor c_res_role (l_role_name jtf_rs_roles_vl.role_name%type) is
99: select role_id, role_code
100: from jtf_rs_roles_vl
101: where role_name = l_role_name;
102:

Line 100: from jtf_rs_roles_vl

96: where group_name = l_resource_group;
97:
98: cursor c_res_role (l_role_name jtf_rs_roles_vl.role_name%type) is
99: select role_id, role_code
100: from jtf_rs_roles_vl
101: where role_name = l_role_name;
102:
103: cursor c_get_user_id (l_user_name jtf_rs_resource_extns.user_name%type) is
104: select user_id