DBA Data[Home] [Help]

APPS.CTO_UPDATE_ITEMS_PK dependencies on CST_COST_TYPES

Line 989: v_cto_cost_type_name cst_cost_types.cost_type%type;

985:
986: l_rt_cicd_summary cicd_summary_rec_tab ;
987:
988:
989: v_cto_cost_type_name cst_cost_types.cost_type%type;
990:
991: --kkonada R12
992: --for mtl_cross_references_b
993: --bug# 4539578

Line 1523: from cst_cost_types

1519: /* begin bugfix 4057651, default CTO cost type id = 7 if it does not exist */
1520: begin
1521:
1522: select cost_type_id into l_cto_cost_type_id
1523: from cst_cost_types
1524: where cost_type = 'CTO' ;
1525:
1526: exception
1527: when no_data_found then

Line 1538: from cst_cost_types

1534: l_cto_cost_type_id := 7 ;
1535:
1536: begin
1537: select cost_type into v_cto_cost_type_name
1538: from cst_cost_types
1539: where cost_type_id = l_cto_cost_type_id ;
1540:
1541: IF PG_DEBUG <> 0 THEN
1542: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || l_cto_cost_type_id ||