DBA Data[Home] [Help]

APPS.WSMPVCPD dependencies on WSM_COPRODUCT_SPLIT_PERC

Line 440: from WSM_COPRODUCT_SPLIT_PERC

436: e_invalid_split_total EXCEPTION;
437: x_split_total NUMBER := NULL;
438:
439: CURSOR c_total is select distinct effectivity_date
440: from WSM_COPRODUCT_SPLIT_PERC
441: where co_product_group_id=x_co_product_group_id;
442:
443: BEGIN
444:

Line 467: FROM wsm_coproduct_split_perc bcp

463: FOR e_rec IN c_total LOOP
464:
465: SELECT sum (nvl(bcp.split,0))
466: INTO x_split_total
467: FROM wsm_coproduct_split_perc bcp
468: WHERE bcp.co_product_group_id = x_co_product_group_id
469: AND effectivity_date = e_rec.effectivity_date;
470:
471: IF (x_split_total <> 100) THEN