APPS.JTF_RS_IMPORT_USER_PUB dependencies on JTF_IAPP_FAMILIES_VL

Line 30: l_nav_group1 jtf_iapp_families_vl.app_family_display_name%type;

26: l_user_name jtf_rs_resource_extns.user_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;

Line 34: l_nav_group2 jtf_iapp_families_vl.app_family_display_name%type;

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;
37:
38: l_employee_number per_all_people_f.employee_number%type ;

Line 69: cursor c_nav_group (l_nav_group jtf_iapp_families_vl.app_family_display_name%type) is

65: select resource_id
66: from jtf_rs_resource_extns
67: where user_id = l_mgr_user_id;
68:
69: cursor c_nav_group (l_nav_group jtf_iapp_families_vl.app_family_display_name%type) is
70: select app_family_id
71: from jtf_iapp_families_vl
72: where app_family_display_name = l_nav_group;
73:

Line 71: from jtf_iapp_families_vl

67: where user_id = l_mgr_user_id;
68:
69: cursor c_nav_group (l_nav_group jtf_iapp_families_vl.app_family_display_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