APPS.CN_OVER_ASSIGN_PVT dependencies on CN_SRP_ROLE_DTLS

Line 35: FROM cn_srp_role_dtls_v

31:
32: CURSOR srp_role_info IS
33: SELECT Trunc(start_date) start_date,
34: Nvl(Trunc(end_date),p_end_date) end_date
35: FROM cn_srp_role_dtls_v
36: WHERE srp_role_id = p_srp_role_id;
37:
38: CURSOR c_quota_amount
39: (c_srp_role_id NUMBER,

Line 156: FROM cn_srp_role_dtls_v

152:
153: SELECT srp_role_id,
154: Greatest(c_start_date,Trunc(start_date)) start_date,
155: Least(Nvl(Trunc(end_date),c_end_date),c_end_date) end_date
156: FROM cn_srp_role_dtls_v
157: WHERE srp_id = c_srp_id
158: AND role_model_id is null -- "CHANGED FOR MODELING IMPACT"
159: AND overlay_flag = 'N'
160: AND Greatest(Trunc(start_date),c_start_date) <=

Line 183: FROM cn_srp_role_dtls

179: eachcg.start_date,eachcg.end_date)LOOP
180: l_check := 0;
181: BEGIN
182: SELECT 1 INTO l_check
183: FROM cn_srp_role_dtls
184: WHERE srp_role_id = eachdirect.srp_role_id
185: AND org_code = p_org_code
186: AND overlay_flag = 'N'
187: ;

Line 314: -- because cannot join with cn_srp_role_dtls_v here for performance issue

310:
311: l_srp_info c_srp_info%ROWTYPE;
312:
313: -- the prorate_rate is not complete yet. Complete in the code below.
314: -- because cannot join with cn_srp_role_dtls_v here for performance issue
315: CURSOR mgr_srp_role_list
316: (c_comp_group_id NUMBER,c_start_date DATE, c_end_date DATE) IS
317: SELECT msg.srp_role_id,
318: (Least(Nvl(Trunc(msg.end_date_active),c_end_date), c_end_date) -

Line 381: FROM cn_srp_role_dtls_v

377:
378: SELECT srp_role_id,
379: Greatest(c_start_date,Trunc(start_date)) start_date,
380: Least(Nvl(Trunc(end_date),c_end_date),c_end_date) end_date
381: FROM cn_srp_role_dtls_v
382: WHERE srp_id = c_srp_id
383: AND role_model_id is null -- "CHANGED FOR MODELING IMPACT"
384: AND overlay_flag = 'N'
385: AND Greatest(Trunc(start_date),c_start_date) <=

Line 446: FROM cn_srp_role_dtls_v srd

442: (eachmgr.prorate_rate+1)/
443: (Nvl(Trunc(srd.end_date),l_srp_info.end_date) + 1 -
444: Trunc(srd.start_date)) prorate_rate
445: INTO eachmgr.prorate_rate
446: FROM cn_srp_role_dtls_v srd
447: WHERE srd.srp_role_id = eachmgr.srp_role_id
448: ;
449: END;
450:

Line 457: FROM cn_srp_role_dtls

453: (eachmgr.srp_role_id,eachmgr.prorate_rate) LOOP
454: l_check := 0;
455: BEGIN
456: SELECT 1 INTO l_check
457: FROM cn_srp_role_dtls
458: WHERE srp_role_id = eachmgr.srp_role_id
459: AND org_code = p_org_code
460: ;
461: EXCEPTION

Line 523: FROM cn_srp_role_dtls

519: LOOP
520: l_check := 0;
521: BEGIN
522: SELECT 1 INTO l_check
523: FROM cn_srp_role_dtls
524: WHERE srp_role_id = eachdirect.srp_role_id
525: AND org_code = p_org_code
526: AND overlay_flag = 'N'
527: ;

Line 571: FROM cn_srp_role_dtls

567: LOOP
568: l_check := 0;
569: BEGIN
570: SELECT 1 INTO l_check
571: FROM cn_srp_role_dtls
572: WHERE srp_role_id = eachdirect.srp_role_id
573: AND org_code = p_org_code
574: AND overlay_flag = 'N'
575: ;