APPS.CSTPACLM dependencies on CST_QUANTITY_LAYERS

Line 23: from cst_quantity_layers

19: o_err_msg := '';
20:
21: select layer_id
22: into retval
23: from cst_quantity_layers
24: where organization_id = i_org_id
25: and inventory_item_id = i_item_id
26: and cost_group_id = i_cost_group_id;
27:

Line 64: FROM CST_QUANTITY_LAYERS

60: INTO retval
61: FROM CST_LAYER_COST_DETAILS
62: WHERE LAYER_ID =
63: (SELECT LAYER_ID
64: FROM CST_QUANTITY_LAYERS
65: WHERE ORGANIZATION_ID = i_org_id
66: AND INVENTORY_ITEM_ID = i_item_id
67: AND COST_GROUP_ID = i_cost_group_id);
68:

Line 120: select cst_quantity_layers_s.nextval

116: /*
117: ** if the layer_id is 0, then the layer doesn't exist, so we
118: ** should create it
119: */
120: select cst_quantity_layers_s.nextval
121: into l_layer_id
122: from dual;
123:
124: BEGIN

Line 125: insert into cst_quantity_layers (

121: into l_layer_id
122: from dual;
123:
124: BEGIN
125: insert into cst_quantity_layers (
126: layer_id,
127: organization_id,
128: inventory_item_id,
129: cost_group_id,