DBA Data[Home] [Help]

APPS.CSTPACIT dependencies on CST_QUANTITY_LAYERS

Line 649: FROM CST_QUANTITY_LAYERS CL,

645:
646:
647: cursor cost_elmt_ids is
648: SELECT CLCD.COST_ELEMENT_ID
649: FROM CST_QUANTITY_LAYERS CL,
650: CST_LAYER_COST_DETAILS CLCD
651: WHERE CL.LAYER_ID = l_layer_id
652: AND CLCD.LAYER_ID = l_layer_id;
653:

Line 705: FROM CST_QUANTITY_LAYERS

701: end if;
702:
703: SELECT ITEM_COST
704: INTO cl_item_cost
705: FROM CST_QUANTITY_LAYERS
706: WHERE LAYER_ID = l_layer_id;
707:
708: /* for the case of item cost equal zero */
709: /* split cost evenly among cost elements */

Line 760: FROM CST_QUANTITY_LAYERS CL, CST_LAYER_COST_DETAILS CLCD

756: i_request_id,
757: i_prog_appl_id,
758: i_prog_id,
759: sysdate
760: FROM CST_QUANTITY_LAYERS CL, CST_LAYER_COST_DETAILS CLCD
761: WHERE CL.LAYER_ID = l_layer_id
762: AND CLCD.LAYER_ID = l_layer_id;
763:
764: /* If layer detail does not exist, then insert a new row