APPS.JTF_RS_IMPORT_USER_PUB dependencies on PER_ALL_PEOPLE_F

Line 38: l_employee_number per_all_people_f.employee_number%type ;

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 ;
41:
42: l_business_group_id per_all_people_f.business_group_id%type;

Line 42: l_business_group_id per_all_people_f.business_group_id%type;

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:
45: cursor upload_data is
46: select column1, column2, column3, column4, column5, column6, column7, column8,

Line 88: cursor c_method_emp_gen (l_business_group_id per_all_people_f.business_group_id%type) is

84: and jpm.application_id = fr.application_id
85: and fr.responsibility_id = l_responsibility_id
86: and jif.app_family_id = l_app_family_id;
87:
88: cursor c_method_emp_gen (l_business_group_id per_all_people_f.business_group_id%type) is
89: select method_of_generation_emp_num
90: from per_business_groups
91: where business_group_id =l_business_group_id;
92: