APPS.CN_CALC_ROLLUP_PVT dependencies on CN_SRP_COMP_GROUPS_V

Line 35: FROM cn_srp_comp_groups_v

31: INDEX BY BINARY_INTEGER;
32:
33: CURSOR GROUP_ID( p_processed_date DATE, p_salesrep_id NUMBER ) IS
34: SELECT comp_group_id
35: FROM cn_srp_comp_groups_v
36: WHERE salesrep_id = p_salesrep_id
37: AND org_id = g_org_id
38: AND p_processed_date >= start_date_active
39: AND ( end_date_active IS NULL OR p_processed_date <= end_date_active )

Line 44: FROM cn_srp_comp_groups_v

40: AND ROWNUM = 1;
41:
42: CURSOR verify_group( p_processed_date DATE, p_salesrep_id NUMBER, p_comp_group_id NUMBER ) IS
43: SELECT comp_group_id
44: FROM cn_srp_comp_groups_v
45: WHERE salesrep_id = p_salesrep_id
46: AND org_id = g_org_id
47: AND p_processed_date > start_date_active
48: AND ( end_date_active IS NULL OR p_processed_date <= end_date_active )

Line 480: FROM cn_srp_comp_groups_v

476: AND NVL( rollup_date, processed_date ) BETWEEN p_start_date AND p_end_date;
477:
478: CURSOR role_mgr_flag_c( x_salesrep_id NUMBER, x_comp_group_id NUMBER, x_start_date DATE, x_end_date DATE ) IS
479: SELECT manager_flag
480: FROM cn_srp_comp_groups_v
481: WHERE salesrep_id = x_salesrep_id
482: AND org_id = g_org_id
483: AND comp_group_id = x_comp_group_id
484: AND start_date_active <= x_start_date

Line 487: l_mgr_role_flag cn_srp_comp_groups_v.manager_flag%TYPE;

483: AND comp_group_id = x_comp_group_id
484: AND start_date_active <= x_start_date
485: AND NVL( end_date_active, x_end_date ) >= x_end_date;
486:
487: l_mgr_role_flag cn_srp_comp_groups_v.manager_flag%TYPE;
488: BEGIN
489: l_group.GROUP_ID := p_comp_group_id;
490: l_group.start_date := p_start_date;
491: l_group.end_date := p_end_date;

Line 665: FROM cn_srp_comp_groups_v a1

661: GROUP BY salesrep_id, comp_group_id;
662:
663: CURSOR path_check( p_rollup_date DATE, p_parent_salesrep_id NUMBER, p_child_salesrep_id NUMBER ) IS
664: SELECT 1
665: FROM cn_srp_comp_groups_v a1
666: WHERE p_rollup_date BETWEEN start_date_active AND NVL( end_date_active, p_rollup_date )
667: AND salesrep_id = p_parent_salesrep_id
668: AND org_id = g_org_id
669: AND EXISTS(

Line 675: FROM cn_srp_comp_groups_v

671: FROM cn_groups_denorm_v
672: WHERE parent_group_id = a1.comp_group_id
673: AND GROUP_ID IN(
674: SELECT comp_group_id
675: FROM cn_srp_comp_groups_v
676: WHERE p_rollup_date BETWEEN start_date_active AND NVL( end_date_active, p_rollup_date )
677: AND salesrep_id = p_child_salesrep_id
678: AND org_id = g_org_id )
679: AND p_rollup_date BETWEEN start_date_active AND NVL( end_date_active, p_rollup_date ) );