APPS.CSTPLENG dependencies on MTL_ACTUAL_COST_SUBELEMENT

Line 3716: from mtl_actual_cost_subelement

3712: l_stmt_num := 25;
3713:
3714: select count(*)
3715: into l_macs_ovhd
3716: from mtl_actual_cost_subelement
3717: where transaction_id = i_txn_id
3718: and organization_id = i_org_id
3719: and layer_id = i_layer_id
3720: and cost_element_id = 2

Line 3780: Insert into mtl_actual_cost_subelement(

3776: if(l_debug = 'Y') then
3777: fnd_file.put_line(fnd_file.log, 'Inserting into MACS');
3778: end if;
3779:
3780: Insert into mtl_actual_cost_subelement(
3781: transaction_id,
3782: organization_id,
3783: layer_id,
3784: cost_element_id,

Line 3893: Insert into mtl_actual_cost_subelement(

3889: if(l_debug = 'Y') then
3890: fnd_file.put_line(fnd_file.log, 'Inserting into MACS');
3891: end if;
3892:
3893: Insert into mtl_actual_cost_subelement(
3894: transaction_id,
3895: organization_id,
3896: layer_id,
3897: cost_element_id,

Line 3942: from mtl_actual_cost_subelement

3938: l_stmt_num := 60;
3939:
3940: select count(*)
3941: into l_mat_ovhds
3942: from mtl_actual_cost_subelement
3943: where transaction_id = i_txn_id
3944: and organization_id = i_org_id
3945: and layer_id = i_layer_id
3946: and cost_element_id = 2

Line 3987: from mtl_actual_cost_subelement

3983:
3984: l_stmt_num := 70;
3985: select sum(actual_cost)
3986: into l_ovhd_cost
3987: from mtl_actual_cost_subelement
3988: where transaction_id = i_txn_id
3989: and organization_id = i_org_id
3990: and layer_id = i_layer_id
3991: and cost_element_id = 2;