APPS.CSTPPWAC dependencies on MTL_PAC_TXN_COST_DETAILS

Line 1553: from mtl_pac_txn_cost_details

1549: l_stmt_num := 10;
1550:
1551: select count(*)
1552: into l_txn_cost_exist
1553: from mtl_pac_txn_cost_details
1554: where transaction_id = i_txn_id
1555: and cost_group_id = i_cost_group_id
1556: and pac_period_id = i_pac_period_id;
1557:

Line 1611: FROM mtl_pac_txn_cost_details mptcd

1607: 'Y',
1608: 'N',
1609: SYSDATE,
1610: i_txn_category
1611: FROM mtl_pac_txn_cost_details mptcd
1612: WHERE transaction_id = i_txn_id
1613: AND pac_period_id = i_pac_period_id
1614: AND cost_group_id = i_cost_group_id;
1615:

Line 2841: FROM mtl_pac_txn_cost_details mptcd

2837: FROM cst_pac_item_cost_details cpicd
2838: WHERE cpicd.cost_layer_id = i_cost_layer_id
2839: AND not exists (
2840: SELECT 'not exists in mptcd'
2841: FROM mtl_pac_txn_cost_details mptcd
2842: WHERE mptcd.transaction_id = i_txn_id
2843: AND mptcd.pac_period_id = i_pac_period_id
2844: AND mptcd.cost_group_id = i_cost_group_id
2845: AND mptcd.cost_element_id = cpicd.cost_element_id

Line 2951: FROM mtl_pac_txn_cost_details mptcd,

2947: ),
2948: 0
2949: )
2950: )
2951: FROM mtl_pac_txn_cost_details mptcd,
2952: cst_pac_item_cost_details cpicd,
2953: cst_pac_quantity_layers cpql
2954: WHERE mptcd.transaction_id = i_txn_id
2955: AND mptcd.pac_period_id = i_pac_period_id

Line 2971: FROM mtl_pac_txn_cost_details mptcd

2967:
2968: l_stmt_num := 30;
2969: SELECT DECODE(MAX(value_change),NULL, 1, 0)
2970: INTO l_value_change_flag
2971: FROM mtl_pac_txn_cost_details mptcd
2972: WHERE mptcd.transaction_id = i_txn_id
2973: AND mptcd.pac_period_id = i_pac_period_id
2974: AND mptcd.cost_group_id = i_cost_group_id;
2975: