APPS.CST_ITEM_COST_IMPORT_INTERFACE dependencies on CST_COST_ELEMENTS

Line 207: AND NOT EXISTS( Select 1 from cst_cost_elements cce where

203: error_code = 'CST_INVALID_COSTELEMENT',
204: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_COSTELEMENT'),1,240)
205: WHERE group_id = SEQ_NEXTVAL
206: AND error_flag is null
207: AND NOT EXISTS( Select 1 from cst_cost_elements cce where
208: NVL(ct.cost_element_id,cce.cost_element_id)= cce.cost_element_id AND NVL(ct.cost_element,cce.cost_element) = cce.cost_element
209: );
210:
211: l_stmt_no := 140;

Line 214: ct.cost_element_id = (select cost_element_id from cst_cost_elements cce

210:
211: l_stmt_no := 140;
212:
213: Update CST_ITEM_CST_DTLS_INTERFACE ct set
214: ct.cost_element_id = (select cost_element_id from cst_cost_elements cce
215: WHERE cce.cost_element = ct.cost_element)
216: WHERE ct.cost_element_id is null
217: AND ct.group_id = SEQ_NEXTVAL
218: AND ct.error_flag is null;