APPS.CSTPACIR dependencies on CST_LAYER_COST_DETAILS

Line 39: * 1. If a new cost element exists in cst_layer_cost_details*

35: stmt_num := 10;
36:
37:
38: /***********************************************************
39: * 1. If a new cost element exists in cst_layer_cost_details*
40: * which did not exist during the last update, or *
41: * 2. This is the first issue being costed for the job, then*
42: * INSERT is required. *
43: ***********************************************************/

Line 78: from CST_LAYER_COST_DETAILS c

74: i_request_id,
75: i_prog_id,
76: i_prog_appl_id,
77: SYSDATE
78: from CST_LAYER_COST_DETAILS c
79: WHERE
80: c.LAYER_ID = i_layer_id AND
81: NOT EXISTS
82: (

Line 138: CST_LAYER_COST_DETAILS c

134: SYSDATE,
135: nvl(w.applied_matl_value,0)+
136: (-1*i_txn_qty)*SUM(decode(l_zero_cost_flag, 1, 0, ITEM_COST))
137: from
138: CST_LAYER_COST_DETAILS c
139: WHERE
140: c.LAYER_ID = i_layer_id AND
141: c.COST_ELEMENT_ID=w.COST_ELEMENT_ID
142: GROUP BY c.COST_ELEMENT_ID

Line 151: CST_LAYER_COST_DETAILS c2

147: w.ORGANIZATION_ID=i_org_id and
148: w.OPERATION_SEQ_NUM=i_op_seq_num
149: AND exists
150: (select 'layer exists' from
151: CST_LAYER_COST_DETAILS c2
152: where c2.LAYER_ID = i_layer_id
153: and c2.cost_element_id = w.cost_element_id);
154:
155: