DBA Data[Home] [Help]

APPS.CN_CALC_ROLLUP_PVT dependencies on CN_SRP_INTEL_PERIODS_ALL

Line 409: UPDATE cn_srp_intel_periods_all

405: AND processed_date = eachdate.processed_date
406: AND NVL( parent_header_id, -1 ) = -1
407: AND NVL( rollup_date, processed_date ) = NVL( eachdate.rollup_date, eachdate.processed_date );
408:
409: UPDATE cn_srp_intel_periods_all
410: SET process_all_flag = 'Y'
411: WHERE period_id = eachdate.processed_period_id
412: AND org_id = g_org_id
413: AND salesrep_id IN(

Line 807: UPDATE cn_srp_intel_periods_all

803: WHERE eachtrx.commission_header_id IN (commission_header_id, parent_header_id)
804: );
805:
806: IF ( SQL%FOUND ) THEN
807: UPDATE cn_srp_intel_periods_all
808: SET process_all_flag = 'Y'
809: WHERE salesrep_id = l_ancestors_tbl( l_ancestor ).salesrep_id
810: AND org_id = g_org_id
811: AND period_id = eachtrx.processed_period_id;