APPS.CN_OVER_ASSIGN_PVT dependencies on CN_SRP_ROLE_DTLS_V

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 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: