APPS.CN_FORMULA_COMMON_PKG dependencies on CN_SRP_COMP_GROUPS_V

Line 2636: FROM cn_srp_comp_groups_v

2632: AND cl.processed_date BETWEEN p_start_date AND p_end_date
2633: AND cl.org_id = l_org_id
2634: AND ( (p_role_id IS NOT NULL AND cl.role_id = p_role_id ) OR p_role_id IS NULL )
2635: AND NOT exists (SELECT 1
2636: FROM cn_srp_comp_groups_v
2637: WHERE comp_group_id = cl.credited_comp_group_id
2638: AND salesrep_id = cl.credited_salesrep_id
2639: AND role_id = cl.role_id
2640: AND org_id = cl.org_id

Line 2657: from cn_srp_comp_groups_v

2653: AND cl.direct_salesrep_id <> p_salesrep_id
2654: AND cl.processed_period_id = p_period_id
2655: AND cl.processed_date BETWEEN p_start_date AND p_end_date
2656: and not exists (select 1
2657: from cn_srp_comp_groups_v
2658: where comp_group_id = p_comp_group_id
2659: and salesrep_id = cl.credited_salesrep_id
2660: and cl.processed_date between start_date_active and nvl(end_date_active, cl.processed_date)
2661: and org_id = cl.org_id

Line 2664: from cn_srp_comp_groups_v

2660: and cl.processed_date between start_date_active and nvl(end_date_active, cl.processed_date)
2661: and org_id = cl.org_id
2662: and manager_flag = 'Y')
2663: and exists( select 1
2664: from cn_srp_comp_groups_v
2665: where comp_group_id = p_comp_group_id
2666: and salesrep_id = cl.direct_salesrep_id
2667: and org_id = cl.org_id
2668: and cl.processed_date between start_date_active and nvl(end_date_active, cl.processed_date));

Line 2834: FROM cn_srp_comp_groups_v

2830: AND cl.processed_date BETWEEN l_log.start_date AND l_log.end_date
2831: AND cl.org_id = l_org_id
2832: AND ((l_log.role_id IS NOT NULL AND cl.role_id = l_log.role_id ) OR l_log.role_id IS NULL )
2833: AND NOT exists (SELECT 1
2834: FROM cn_srp_comp_groups_v
2835: WHERE comp_group_id = l_log.comp_group_id
2836: AND role_id = cl.role_id
2837: AND salesrep_id = cl.credited_salesrep_id
2838: AND org_id = cl.org_id

Line 2881: from cn_srp_comp_groups_v

2877: AND cl.processed_period_id = l_log.period_id
2878: AND cl.processed_date BETWEEN l_log.start_date AND l_log.end_date
2879: AND cl.org_id = l_org_id
2880: and not exists (select 1
2881: from cn_srp_comp_groups_v
2882: where comp_group_id = l_log.comp_group_id
2883: and salesrep_id = cl.credited_salesrep_id
2884: and cl.processed_date between start_date_active and nvl(end_date_active, cl.processed_date)
2885: and manager_flag = 'Y'

Line 2888: from cn_srp_comp_groups_v

2884: and cl.processed_date between start_date_active and nvl(end_date_active, cl.processed_date)
2885: and manager_flag = 'Y'
2886: and org_id = cl.org_id)
2887: and exists( select 1
2888: from cn_srp_comp_groups_v
2889: where comp_group_id = l_log.comp_group_id
2890: and salesrep_id = cl.direct_salesrep_id
2891: and cl.processed_date between start_date_active and nvl(end_date_active, cl.processed_date)
2892: and org_id = cl.org_id);