APPS.CSTPAVCP dependencies on MTL_ACTUAL_COST_SUBELEMENT

Line 3108: Insert into mtl_actual_cost_subelement(

3104: end if;
3105:
3106: l_stmt_num := 30;
3107:
3108: Insert into mtl_actual_cost_subelement(
3109: transaction_id,
3110: organization_id,
3111: layer_id,
3112: cost_element_id,

Line 3216: Insert into mtl_actual_cost_subelement(

3212: end if ;
3213:
3214:
3215: l_stmt_num := 70;
3216: Insert into mtl_actual_cost_subelement(
3217: transaction_id,
3218: organization_id,
3219: layer_id,
3220: cost_element_id,

Line 3261: from mtl_actual_cost_subelement

3257:
3258: l_stmt_num := 80;
3259: select count(*)
3260: into l_mat_ovhds
3261: from mtl_actual_cost_subelement
3262: where transaction_id = i_txn_id
3263: and organization_id = i_org_id
3264: and layer_id = i_layer_id
3265: and cost_element_id = 2

Line 3295: from mtl_actual_cost_subelement

3291: if (l_mcacd_ovhd > 0) then --update mcacd
3292: l_stmt_num := 85;
3293: select sum(actual_cost)
3294: into l_ovhd_cost
3295: from mtl_actual_cost_subelement
3296: where transaction_id = i_txn_id
3297: and organization_id = i_org_id
3298: and layer_id = i_layer_id
3299: and cost_element_id = 2;

Line 3360: from mtl_actual_cost_subelement

3356: NULL,
3357: 'Y',
3358: 0,
3359: 'N'
3360: from mtl_actual_cost_subelement
3361: where transaction_id = i_txn_id
3362: and organization_id = i_org_id
3363: and layer_id = i_layer_id
3364: and cost_element_id = 2;

Line 3418: from mtl_actual_cost_subelement

3414: NULL,
3415: 'Y',
3416: 0,
3417: 'N'
3418: from mtl_actual_cost_subelement
3419: where transaction_id = i_txn_id
3420: and organization_id = i_org_id
3421: and layer_id = i_layer_id
3422: and cost_element_id = 2;

Line 5059: Insert into mtl_actual_cost_subelement(

5055: else
5056: if g_debug = 'Y' then
5057: FND_FILE.PUT_LINE(fnd_file.log, to_char(l_stmt_num) || 'Insert into MACS from CICD');
5058: end if;
5059: Insert into mtl_actual_cost_subelement(
5060: layer_id,
5061: transaction_id,
5062: organization_id,
5063: cost_element_id,