APPS.CSTPAVCP dependencies on MTL_ACTUAL_COST_SUBELEMENT

Line 2939: Insert into mtl_actual_cost_subelement(

2935: end if;
2936:
2937: l_stmt_num := 30;
2938:
2939: Insert into mtl_actual_cost_subelement(
2940: transaction_id,
2941: organization_id,
2942: layer_id,
2943: cost_element_id,

Line 3045: Insert into mtl_actual_cost_subelement(

3041: end if ;
3042:
3043:
3044: l_stmt_num := 70;
3045: Insert into mtl_actual_cost_subelement(
3046: transaction_id,
3047: organization_id,
3048: layer_id,
3049: cost_element_id,

Line 3090: from mtl_actual_cost_subelement

3086:
3087: l_stmt_num := 80;
3088: select count(*)
3089: into l_mat_ovhds
3090: from mtl_actual_cost_subelement
3091: where transaction_id = i_txn_id
3092: and organization_id = i_org_id
3093: and layer_id = i_layer_id
3094: and cost_element_id = 2

Line 3124: from mtl_actual_cost_subelement

3120: if (l_mcacd_ovhd > 0) then --update mcacd
3121: l_stmt_num := 85;
3122: select sum(actual_cost)
3123: into l_ovhd_cost
3124: from mtl_actual_cost_subelement
3125: where transaction_id = i_txn_id
3126: and organization_id = i_org_id
3127: and layer_id = i_layer_id
3128: and cost_element_id = 2;

Line 3189: from mtl_actual_cost_subelement

3185: NULL,
3186: 'Y',
3187: 0,
3188: 'N'
3189: from mtl_actual_cost_subelement
3190: where transaction_id = i_txn_id
3191: and organization_id = i_org_id
3192: and layer_id = i_layer_id
3193: and cost_element_id = 2;

Line 3247: from mtl_actual_cost_subelement

3243: NULL,
3244: 'Y',
3245: 0,
3246: 'N'
3247: from mtl_actual_cost_subelement
3248: where transaction_id = i_txn_id
3249: and organization_id = i_org_id
3250: and layer_id = i_layer_id
3251: and cost_element_id = 2;

Line 4884: Insert into mtl_actual_cost_subelement(

4880: else
4881: if g_debug = 'Y' then
4882: FND_FILE.PUT_LINE(fnd_file.log, to_char(l_stmt_num) || 'Insert into MACS from CICD');
4883: end if;
4884: Insert into mtl_actual_cost_subelement(
4885: layer_id,
4886: transaction_id,
4887: organization_id,
4888: cost_element_id,