APPS.CN_CALC_ROLLUP_PVT dependencies on CN_COMP_PLANS

Line 173: FROM cn_srp_plan_assigns srpplans, cn_comp_plans compplans

169: l_srp_sum_flag VARCHAR2( 1 );
170:
171: CURSOR l_sum_flag IS
172: SELECT NVL( compplans.sum_trx_flag, 'N' )
173: FROM cn_srp_plan_assigns srpplans, cn_comp_plans compplans
174: WHERE compplans.comp_plan_id = srpplans.comp_plan_id
175: AND p_processed_date BETWEEN srpplans.start_date AND NVL( srpplans.end_date, p_processed_date )
176: AND srpplans.salesrep_id = p_salesrep_id;
177: BEGIN