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(
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;