APPS.CN_OVER_ASSIGN_PVT dependencies on CN_QM_MGR_SRP_GROUPS

Line 57: -- cn_qm_mgr_srp_groups(cn_srp_role) end_date cannot be null

53: -- Get plan assign start/end period
54: OPEN srp_role_info;
55: FETCH srp_role_info INTO l_sr_start_date , l_sr_end_date;
56:
57: -- cn_qm_mgr_srp_groups(cn_srp_role) end_date cannot be null
58: IF l_sr_end_date IS NULL THEN
59: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
60: FND_MESSAGE.SET_NAME ('CN' , 'CN_QM_SR_ED_NULL');
61: FND_MSG_PUB.Add;

Line 141: cn_qm_mgr_srp_groups msg

137: c_end_date) end_date,
138: msg.manager_flag,
139: msg.member_flag
140: FROM
141: cn_qm_mgr_srp_groups msg
142: WHERE
143: msg.comp_group_id = c_comp_group_id
144: AND Greatest(Trunc(msg.start_date_active), c_start_date) <=
145: Least(Nvl(Trunc(msg.end_date_active),c_end_date), c_end_date)

Line 308: FROM cn_qm_mgr_srp_groups

304: SELECT srp_role_id,srp_id,role_id,
305: Trunc(start_date_active) start_date,
306: Trunc(end_date_active) end_date,comp_group_id ,
307: manager_flag,member_flag ,group_name
308: FROM cn_qm_mgr_srp_groups
309: WHERE qm_mgr_srp_group_id = p_qm_mgr_srp_group_id ;
310:
311: l_srp_info c_srp_info%ROWTYPE;
312:

Line 320: FROM cn_qm_mgr_srp_groups msg

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) -
319: Greatest(Trunc(msg.start_date_active), c_start_date)) prorate_rate
320: FROM cn_qm_mgr_srp_groups msg
321: WHERE msg.manager_flag = 'Y'
322: AND msg.comp_group_id = c_comp_group_id
323: AND Greatest(Trunc(msg.start_date_active), c_start_date) <=
324: Least(Nvl(Trunc(msg.end_date_active),c_end_date), c_end_date)

Line 366: cn_qm_mgr_srp_groups msg

362: c_end_date) end_date,
363: msg.manager_flag,
364: msg.member_flag
365: FROM
366: cn_qm_mgr_srp_groups msg
367: WHERE
368: msg.comp_group_id = c_comp_group_id
369: AND Greatest(Trunc(msg.start_date_active), c_start_date) <=
370: Least(Nvl(Trunc(msg.end_date_active),c_end_date), c_end_date)

Line 412: -- cn_qm_mgr_srp_groups(cn_srp_role) end_date cannot be null

408: -- get related information about this salesrep
409: OPEN c_srp_info;
410: FETCH c_srp_info INTO l_srp_info;
411:
412: -- cn_qm_mgr_srp_groups(cn_srp_role) end_date cannot be null
413: IF l_srp_info.end_date IS NULL THEN
414: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
415: FND_MESSAGE.SET_NAME ('CN' , 'CN_QM_SR_ED_NULL');
416: FND_MSG_PUB.Add;