APPS.CN_GET_SRP_DATA_PVT dependencies on CN_SRP_HR_DATA

Line 8: select srp_id, name, emp_num from cn_srp_hr_data order by name;

4: PROCEDURE Get_Srp_List
5: (x_srp_data OUT NOCOPY srp_data_tbl_type) IS
6:
7: CURSOR get_data IS
8: select srp_id, name, emp_num from cn_srp_hr_data order by name;
9:
10: rownum NUMBER := 0;
11:
12: BEGIN

Line 53: from cn_srp_hr_data s,

49: -- sr.role_id role_id,
50: -- null role_name
51: 1 role_id,
52: ''A'' role_name
53: from cn_srp_hr_data s,
54: cn_srp_role_dtls srd,
55: cn_srp_roles sr,
56: per_jobs j,
57: jtf_rs_group_members sg,

Line 161: from cn_srp_hr_data s

157: s.cost_center,
158: null comp_group_name, null comp_group_id,
159: null job_code, null job_title, null disc_job_title,
160: null role_id, null role_name --recycle rec type
161: from cn_srp_hr_data s
162: where s.srp_id = p_srp_id;
163: BEGIN
164: open c;
165: fetch c into x_srp_data(1);

Line 204: from cn_qm_mgr_srp_groups sg, cn_srp_hr_data sd

200: select sg.role_id, sg.role_name, sg.start_date_active, sg.group_name,
201: nvl(sg.end_date_active, g_end_of_time) end_date_active,
202: sg.srp_id, sd.name srp_name, sd.emp_num, sg.manager_flag,
203: decode(sg.manager_flag, 'Y', sd.name || ' *', sd.name) ast_name
204: from cn_qm_mgr_srp_groups sg, cn_srp_hr_data sd
205: where sg.comp_group_id = l_comp_group_id and sg.srp_id = sd.srp_id;
206:
207: cursor get_parent_groups is
208: select parent_comp_group_id, start_date_active,