APPS.CSTPUMEC dependencies on CST_COST_TYPES

Line 798: l_costtype cst_cost_types.cost_type%TYPE := NULL;

794:
795: -- The next three variables are used to print a warning message with the
796: -- fnd_message utilities.
797: l_orgcode mtl_parameters.organization_code%TYPE := NULL;
798: l_costtype cst_cost_types.cost_type%TYPE := NULL;
799: l_itemname mtl_system_items_kfv.concatenated_segments%TYPE;
800:
801: BEGIN
802:

Line 1099: from cst_cost_types

1095: fnd_message.set_token('ORG', l_orgcode);
1096:
1097: select cost_type
1098: into l_costtype
1099: from cst_cost_types
1100: where cost_type_id = i_cost_type;
1101: fnd_message.set_token('CT', l_costtype);
1102: fnd_file.put_line(fnd_file.log, fnd_message.get);
1103:

Line 1178: FROM cst_item_costs cic1, cst_cost_types cct

1174: AND cicd.cost_type_id = cic.cost_type_id
1175: AND cicd.inventory_item_id = cic.inventory_item_id
1176: AND cicd.rollup_source_type = 1) -- user defined
1177: OR NOT EXISTS (SELECT 'X'
1178: FROM cst_item_costs cic1, cst_cost_types cct
1179: WHERE cic1.organization_id = cic.organization_id
1180: AND cic1.cost_type_id = cct.default_cost_type_id
1181: AND cct.cost_type_id = cic.cost_type_id
1182: AND cic1.inventory_item_id = cic.inventory_item_id))

Line 1202: from cst_cost_types

1198:
1199: if (l_costtype IS NULL) then
1200: select cost_type
1201: into l_costtype
1202: from cst_cost_types
1203: where cost_type_id = i_cost_type;
1204: end if;
1205: fnd_message.set_token('CT', l_costtype);
1206: fnd_file.put_line(fnd_file.log, fnd_message.get);