APPS.CN_SRP_HIER_PROC_PVT dependencies on CN_QM_GROUP_HIER

Line 76: FROM cn_qm_group_hier

72:
73: CURSOR groups_csr IS
74: SELECT parent_comp_group_id parent_group_id,
75: trunc(start_date_active) start_date, trunc(end_date_active) end_date
76: FROM cn_qm_group_hier
77: WHERE comp_group_id = p_group.group_id;
78:
79: BEGIN
80: -- Standard Start of API savepoint

Line 226: FROM cn_qm_group_hier

222: CURSOR groups_csr IS
223: SELECT comp_group_id group_id,
224: trunc(start_date_active) start_date,
225: trunc(end_date_active) end_date
226: FROM cn_qm_group_hier
227: WHERE parent_comp_group_id = p_group.group_id;
228:
229: BEGIN
230: -- Standard Start of API savepoint

Line 398: FROM cn_qm_group_hier

394: WHERE manager_srp_id = p_salesrep_id;
395:
396: CURSOR l_parent_group_csr is
397: SELECT parent_comp_group_id
398: FROM cn_qm_group_hier
399: WHERE comp_group_id = l_comp_group_id
400: AND trunc(start_date_active) <= p_effective_date
401: AND (trunc(end_date_active) >= p_effective_date
402: OR end_date_active IS NULL);

Line 2491: FROM cn_qm_group_hier

2487: WHERE manager_srp_id = p_srp.salesrep_id;
2488:
2489: CURSOR l_parent_group_csr(p_group_id NUMBER) is
2490: SELECT parent_comp_group_id
2491: FROM cn_qm_group_hier
2492: WHERE comp_group_id = p_group_id
2493: AND trunc(start_date_active) <= p_srp.effective_date
2494: AND (trunc(end_date_active) >= p_srp.effective_date
2495: OR end_date_active IS NULL);