APPS.JTF_RS_IMPORT_USER_PUB dependencies on JTF_RS_GROUPS_VL

Line 39: l_resource_group jtf_rs_groups_vl.group_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 ;
41:
42: l_business_group_id per_all_people_f.business_group_id%type;
43: l_mgr_employee_id fnd_user.employee_id%type;

Line 93: cursor c_res_group (l_resource_group jtf_rs_groups_vl.group_name%type) is

89: select method_of_generation_emp_num
90: from per_business_groups
91: where business_group_id =l_business_group_id;
92:
93: cursor c_res_group (l_resource_group jtf_rs_groups_vl.group_name%type) is
94: select group_id
95: from jtf_rs_groups_vl
96: where group_name = l_resource_group;
97:

Line 95: from jtf_rs_groups_vl

91: where business_group_id =l_business_group_id;
92:
93: cursor c_res_group (l_resource_group jtf_rs_groups_vl.group_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