APPS.JTF_RS_IMPORT_USER_PUB dependencies on FND_RESPONSIBILITY_VL

Line 31: l_resp_group1 fnd_responsibility_vl.responsibility_name%type;

27: l_email jtf_rs_resource_extns.source_email%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;

Line 35: l_resp_group2 fnd_responsibility_vl.responsibility_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;
37:
38: l_employee_number per_all_people_f.employee_number%type ;
39: l_resource_group jtf_rs_groups_vl.group_name%type ;

Line 40: l_default_resp 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;
44:

Line 74: cursor c_resp_group (l_resp_group fnd_responsibility_vl.responsibility_name%type) is

70: select app_family_id
71: from jtf_iapp_families_vl
72: where app_family_display_name = l_nav_group;
73:
74: cursor c_resp_group (l_resp_group fnd_responsibility_vl.responsibility_name%type) is
75: select responsibility_id
76: from fnd_responsibility_vl
77: where responsibility_name = l_resp_group;
78:

Line 76: from fnd_responsibility_vl

72: where app_family_display_name = l_nav_group;
73:
74: cursor c_resp_group (l_resp_group fnd_responsibility_vl.responsibility_name%type) is
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