APPS.CST_ITEM_COST_IMPORT_INTERFACE dependencies on CST_COST_ELEMENTS

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

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

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

205:
206: l_stmt_no := 140;
207:
208: Update CST_ITEM_CST_DTLS_INTERFACE ct set
209: ct.cost_element_id = (select cost_element_id from cst_cost_elements cce
210: WHERE cce.cost_element = ct.cost_element)
211: WHERE ct.cost_element_id is null
212: AND ct.group_id = SEQ_NEXTVAL
213: AND ct.error_flag is null;