APPS.CSTPPWAC dependencies on MTL_PAC_COST_SUBELEMENTS

Line 2014: INSERT INTO mtl_pac_cost_subelements(

2010: and cost_layer_id = i_cost_layer_id;
2011:
2012: l_stmt_num := 30;
2013:
2014: INSERT INTO mtl_pac_cost_subelements(
2015: transaction_id,
2016: pac_period_id,
2017: cost_type_id,
2018: cost_group_id,

Line 2066: from mtl_pac_cost_subelements

2062: l_stmt_num := 40;
2063:
2064: select count(*)
2065: into l_mpcs_mat_ovhds
2066: from mtl_pac_cost_subelements
2067: where transaction_id = i_txn_id
2068: and pac_period_id = i_pac_period_id
2069: and cost_group_id = i_cost_group_id
2070: and cost_element_id = 2

Line 2106: FROM mtl_pac_cost_subelements mpcs

2102: i_prg_id,
2103: sysdate,
2104: sum(mpcs.actual_cost) + mpacd.actual_cost,
2105: sysdate
2106: FROM mtl_pac_cost_subelements mpcs
2107: WHERE mpcs.transaction_id = i_txn_id
2108: AND mpcs.pac_period_id = i_pac_period_id
2109: AND mpcs.cost_group_id = i_cost_group_id
2110: AND mpcs.cost_element_id = 2)

Line 2167: FROM mtl_pac_cost_subelements

2163: 'Y',
2164: 'N',
2165: SYSDATE,
2166: i_txn_category
2167: FROM mtl_pac_cost_subelements
2168: WHERE transaction_id = i_txn_id
2169: AND pac_period_id = i_pac_period_id
2170: AND cost_group_id = i_cost_group_id
2171: AND cost_element_id = 2;