DBA Data[Home] [Help]

APPS.CSTPPCIT dependencies on CST_PAC_ITEM_COST_DETAILS

Line 487: FROM CST_PAC_ITEM_COST_DETAILS cpicd

483:
484:
485: CURSOR cost_element_cursor (l_layer_id number) IS
486: SELECT cpicd.cost_element_id
487: FROM CST_PAC_ITEM_COST_DETAILS cpicd
488: WHERE cpicd.cost_layer_id = l_layer_id;
489:
490:
491: BEGIN

Line 555: FROM CST_PAC_ITEM_COST_DETAILS

551:
552: IF (l_item_cost = 0) THEN
553: SELECT count(cost_element_id)
554: INTO cost_element_count
555: FROM CST_PAC_ITEM_COST_DETAILS
556: WHERE cost_layer_id = l_cost_layer_id;
557: END IF;
558:
559: INSERT INTO MTL_PAC_TXN_COST_DETAILS (

Line 605: FROM CST_PAC_ITEM_COST_DETAILS

601: i_request_id,
602: i_prog_appl_id,
603: i_prog_id,
604: sysdate
605: FROM CST_PAC_ITEM_COST_DETAILS
606: WHERE cost_layer_id = l_cost_layer_id;
607:
608: /* If layer detail does not exist, then insert a new row
609: * as a this level material.