APPS.CSTPLENG dependencies on CST_QUANTITY_LAYERS

Line 1717: cst_quantity_layers cql

1713: l_stmt_num := 55;
1714: SELECT COUNT(*)
1715: INTO l_count
1716: FROM cst_inv_layers cil,
1717: cst_quantity_layers cql
1718: WHERE cql.layer_id = i_layer_id
1719: AND cil.inv_layer_id = l_inv_layer_id
1720: AND cil.layer_quantity < 0
1721: AND cil.layer_quantity > cql.layer_quantity;

Line 4459: from cst_quantity_layers cql

4455: /* Added for Bug 15979260 */
4456: -- get the total cost layer quantity from cql
4457: select sum(cql.layer_quantity)
4458: into l_layer_qty
4459: from cst_quantity_layers cql
4460: where cql.layer_id = i_layer_id;
4461:
4462:
4463: l_stmt_num := 25;

Line 4635: ** (cst_quantity_layers) **

4631: end if; -- end updating mmt
4632:
4633: /********************************************************************
4634: ** Update layer quantity and layer costs information **
4635: ** (cst_quantity_layers) **
4636: ********************************************************************/
4637: if i_no_update_qty = 0 then
4638: l_stmt_num := 45;
4639: update cst_quantity_layers cql

Line 4639: update cst_quantity_layers cql

4635: ** (cst_quantity_layers) **
4636: ********************************************************************/
4637: if i_no_update_qty = 0 then
4638: l_stmt_num := 45;
4639: update cst_quantity_layers cql
4640: set (last_updated_by,
4641: last_update_date,
4642: last_update_login,
4643: request_id,

Line 4699: from cst_quantity_layers_v v

4695: tl_item_cost,
4696: item_cost,
4697: unburdened_cost,
4698: burden_cost
4699: from cst_quantity_layers_v v
4700: where v.layer_id = i_layer_id)
4701: where cql.layer_id = i_layer_id
4702: and exists
4703: (select 'there is detail cost'