APPS.CSTPACIR dependencies on CST_LAYER_COST_DETAILS

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

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

Line 82: from CST_LAYER_COST_DETAILS c

78: i_request_id,
79: i_prog_id,
80: i_prog_appl_id,
81: SYSDATE
82: from CST_LAYER_COST_DETAILS c
83: WHERE
84: c.LAYER_ID = i_layer_id AND
85: NOT EXISTS
86: (

Line 110: from CST_LAYER_COST_DETAILS c

106: --entry for this item with cost_element_id 1 and APPLIED_MATL_VALUE 0.
107: stmt_num := 12;
108: select count(*)
109: into l_clcd_count
110: from CST_LAYER_COST_DETAILS c
111: WHERE c.LAYER_ID = i_layer_id
112: and rownum = 1;
113:
114: select count(*)

Line 202: CST_LAYER_COST_DETAILS c

198: SYSDATE,
199: nvl(w.applied_matl_value,0)+
200: (-1*i_txn_qty)*SUM(decode(l_zero_cost_flag, 1, 0, ITEM_COST))
201: from
202: CST_LAYER_COST_DETAILS c
203: WHERE
204: c.LAYER_ID = i_layer_id AND
205: c.COST_ELEMENT_ID=w.COST_ELEMENT_ID
206: GROUP BY c.COST_ELEMENT_ID

Line 215: CST_LAYER_COST_DETAILS c2

211: w.ORGANIZATION_ID=i_org_id and
212: w.OPERATION_SEQ_NUM=i_op_seq_num
213: AND exists
214: (select 'layer exists' from
215: CST_LAYER_COST_DETAILS c2
216: where c2.LAYER_ID = i_layer_id
217: and c2.cost_element_id = w.cost_element_id);
218:
219: