APPS.CSTPLENG dependencies on MTL_ACTUAL_COST_SUBELEMENT

Line 3699: from mtl_actual_cost_subelement

3695: l_stmt_num := 25;
3696:
3697: select count(*)
3698: into l_macs_ovhd
3699: from mtl_actual_cost_subelement
3700: where transaction_id = i_txn_id
3701: and organization_id = i_org_id
3702: and layer_id = i_layer_id
3703: and cost_element_id = 2

Line 3761: Insert into mtl_actual_cost_subelement(

3757: if(l_debug = 'Y') then
3758: fnd_file.put_line(fnd_file.log, 'Inserting into MACS');
3759: end if;
3760:
3761: Insert into mtl_actual_cost_subelement(
3762: transaction_id,
3763: organization_id,
3764: layer_id,
3765: cost_element_id,

Line 3872: Insert into mtl_actual_cost_subelement(

3868: if(l_debug = 'Y') then
3869: fnd_file.put_line(fnd_file.log, 'Inserting into MACS');
3870: end if;
3871:
3872: Insert into mtl_actual_cost_subelement(
3873: transaction_id,
3874: organization_id,
3875: layer_id,
3876: cost_element_id,

Line 3921: from mtl_actual_cost_subelement

3917: l_stmt_num := 60;
3918:
3919: select count(*)
3920: into l_mat_ovhds
3921: from mtl_actual_cost_subelement
3922: where transaction_id = i_txn_id
3923: and organization_id = i_org_id
3924: and layer_id = i_layer_id
3925: and cost_element_id = 2

Line 3966: from mtl_actual_cost_subelement

3962:
3963: l_stmt_num := 70;
3964: select sum(actual_cost)
3965: into l_ovhd_cost
3966: from mtl_actual_cost_subelement
3967: where transaction_id = i_txn_id
3968: and organization_id = i_org_id
3969: and layer_id = i_layer_id
3970: and cost_element_id = 2;