APPS.CSTPACIT dependencies on CST_LAYER_COST_DETAILS

Line 428: FROM CST_LAYER_COST_DETAILS CLCD

424: i_request_id,
425: i_prog_appl_id,
426: i_prog_id,
427: sysdate
428: FROM CST_LAYER_COST_DETAILS CLCD
429: WHERE CLCD.LAYER_ID = l_layer_id;
430:
431: UPDATE MTL_CST_TXN_COST_DETAILS mctcd
432: set (VALUE_CHANGE,

Line 650: CST_LAYER_COST_DETAILS CLCD

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:
654:

Line 714: FROM CST_LAYER_COST_DETAILS

710:
711: if (cl_item_cost = 0) then
712: SELECT count(COST_ELEMENT_ID)
713: INTO cost_element_count
714: FROM CST_LAYER_COST_DETAILS
715: WHERE LAYER_ID = l_layer_id;
716: end if;
717:
718: INSERT INTO MTL_CST_TXN_COST_DETAILS (

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