APPS.CN_FORMULA_COMMON_PKG dependencies on CN_SRP_COMP_GROUPS_V

Line 2652: FROM cn_srp_comp_groups_v

2648: AND cl.processed_date BETWEEN p_start_date AND p_end_date
2649: AND cl.org_id = l_org_id
2650: AND ( (p_role_id IS NOT NULL AND cl.role_id = p_role_id ) OR p_role_id IS NULL )
2651: AND NOT exists (SELECT 1
2652: FROM cn_srp_comp_groups_v
2653: WHERE comp_group_id = cl.credited_comp_group_id
2654: AND salesrep_id = cl.credited_salesrep_id
2655: AND role_id = cl.role_id
2656: AND org_id = cl.org_id

Line 2673: from cn_srp_comp_groups_v

2669: AND cl.direct_salesrep_id <> p_salesrep_id
2670: AND cl.processed_period_id = p_period_id
2671: AND cl.processed_date BETWEEN p_start_date AND p_end_date
2672: and not exists (select 1
2673: from cn_srp_comp_groups_v
2674: where comp_group_id = p_comp_group_id
2675: and salesrep_id = cl.credited_salesrep_id
2676: and cl.processed_date between start_date_active and nvl(end_date_active, cl.processed_date)
2677: and org_id = cl.org_id

Line 2680: from cn_srp_comp_groups_v

2676: and cl.processed_date between start_date_active and nvl(end_date_active, cl.processed_date)
2677: and org_id = cl.org_id
2678: and manager_flag = 'Y')
2679: and exists( select 1
2680: from cn_srp_comp_groups_v
2681: where comp_group_id = p_comp_group_id
2682: and salesrep_id = cl.direct_salesrep_id
2683: and org_id = cl.org_id
2684: and cl.processed_date between start_date_active and nvl(end_date_active, cl.processed_date));

Line 2850: FROM cn_srp_comp_groups_v

2846: AND cl.processed_date BETWEEN l_log.start_date AND l_log.end_date
2847: AND cl.org_id = l_org_id
2848: AND ((l_log.role_id IS NOT NULL AND cl.role_id = l_log.role_id ) OR l_log.role_id IS NULL )
2849: AND NOT exists (SELECT 1
2850: FROM cn_srp_comp_groups_v
2851: WHERE comp_group_id = l_log.comp_group_id
2852: AND role_id = cl.role_id
2853: AND salesrep_id = cl.credited_salesrep_id
2854: AND org_id = cl.org_id

Line 2897: from cn_srp_comp_groups_v

2893: AND cl.processed_period_id = l_log.period_id
2894: AND cl.processed_date BETWEEN l_log.start_date AND l_log.end_date
2895: AND cl.org_id = l_org_id
2896: and not exists (select 1
2897: from cn_srp_comp_groups_v
2898: where comp_group_id = l_log.comp_group_id
2899: and salesrep_id = cl.credited_salesrep_id
2900: and cl.processed_date between start_date_active and nvl(end_date_active, cl.processed_date)
2901: and manager_flag = 'Y'

Line 2904: from cn_srp_comp_groups_v

2900: and cl.processed_date between start_date_active and nvl(end_date_active, cl.processed_date)
2901: and manager_flag = 'Y'
2902: and org_id = cl.org_id)
2903: and exists( select 1
2904: from cn_srp_comp_groups_v
2905: where comp_group_id = l_log.comp_group_id
2906: and salesrep_id = cl.direct_salesrep_id
2907: and cl.processed_date between start_date_active and nvl(end_date_active, cl.processed_date)
2908: and org_id = cl.org_id);