APPS.CN_PSUM_PVT dependencies on CN_SRP_HR_DATA

Line 122: FROM cn_srp_hr_data

118:
119:
120: SELECT name
121: INTO l_mgr_name
122: FROM cn_srp_hr_data
123: WHERE srp_id = p_mgr_id
124: ;
125:
126:

Line 213: SELECT name INTO l_mgr_name FROM cn_srp_hr_data WHERE srp_id = l_srp_group_rec.salesrep_id;

209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:
212:
213: SELECT name INTO l_mgr_name FROM cn_srp_hr_data WHERE srp_id = l_srp_group_rec.salesrep_id;
214: -- DBMS_OUTPUT.PUT_LINE('************** Entered For Manager ************ ' || l_srp_group_rec.salesrep_id || ',' || l_mgr_name || ' Status is : ' || l_return_status || ' ROWS : ' || l_srp_role_info_tbl.count);
215:
216: IF l_srp_role_info_tbl.COUNT > 0 THEN
217: FOR lcount IN l_srp_role_info_tbl.FIRST .. l_srp_role_info_tbl.LAST LOOP

Line 389: FROM cn_srp_hr_data

385: WHERE RE.RESOURCE_ID = S.RESOURCE_ID AND TO_NUMBER(S.SALESREP_ID) > 0 AND
386: S.SALESREP_ID = p_mgr_id;
387: ELSE
388: SELECT name INTO l_mgr_name
389: FROM cn_srp_hr_data
390: WHERE srp_id = p_mgr_id;
391: END IF;
392:
393:

Line 489: FROM cn_srp_hr_data

485: WHERE RE.RESOURCE_ID = S.RESOURCE_ID AND TO_NUMBER(S.SALESREP_ID) > 0 AND
486: S.SALESREP_ID = l_srp_group_rec.salesrep_id;
487: ELSE
488: SELECT name INTO l_mgr_name
489: FROM cn_srp_hr_data
490: WHERE srp_id = l_srp_group_rec.salesrep_id;
491: END IF;
492:
493: IF l_srp_role_info_tbl.COUNT > 0 THEN