APPS.CSTPAPBR dependencies on WIP_PAC_ACTUAL_COST_DETAILS

Line 8463: from wip_pac_actual_cost_details

8459: l_cost_group_id number ,
8460: l_cost_element number)
8461: IS
8462: select distinct resource_id /* added distinct for bug 3116821 */
8463: from wip_pac_actual_cost_details
8464: where transaction_id = l_transaction_id
8465: and pac_period_id = l_accounting_period_id
8466: and cost_group_id = l_cost_group_id
8467: and cost_element_id = l_cost_element;

Line 8512: from wip_pac_actual_cost_details mpacd

8508: -- --------------------------------
8509: l_stmt_num := 20;
8510: select count(transaction_id)
8511: into l_ele_exist
8512: from wip_pac_actual_cost_details mpacd
8513: where mpacd.transaction_id = i_ae_txn_rec.transaction_id
8514: and mpacd.pac_period_id = i_ae_txn_rec.accounting_period_id
8515: and mpacd.cost_group_id = i_ae_txn_rec.cost_group_id
8516: and rownum < 2; /* 4586534 added rownum filter for perf as its only existence check */

Line 8541: FROM wip_pac_actual_cost_details

8537: SELECT nvl(actual_value ,0) ,
8538: nvl(actual_cost ,0)
8539: INTO l_actual_value,
8540: l_actual_cost
8541: FROM wip_pac_actual_cost_details
8542: WHERE transaction_id = i_ae_txn_rec.transaction_id
8543: AND pac_period_id = i_ae_txn_rec.accounting_period_id
8544: AND cost_group_id = i_ae_txn_rec.cost_group_id;
8545:

Line 8678: from wip_pac_actual_cost_details

8674: select sum(nvl(actual_value,0)),
8675: sum(nvl(actual_cost,0))
8676: into l_actual_value,
8677: l_actual_cost
8678: from wip_pac_actual_cost_details
8679: where transaction_id = i_ae_txn_rec.transaction_id
8680: and pac_period_id = i_ae_txn_rec.accounting_period_id
8681: and cost_group_id = i_ae_txn_rec.cost_group_id
8682: and cost_element_id = cost_element

Line 8690: from wip_pac_actual_cost_details

8686: select nvl(actual_value ,0) ,
8687: nvl(actual_cost ,0)
8688: into l_actual_value,
8689: l_actual_cost
8690: from wip_pac_actual_cost_details
8691: where transaction_id = i_ae_txn_rec.transaction_id
8692: and pac_period_id = i_ae_txn_rec.accounting_period_id
8693: and cost_group_id = i_ae_txn_rec.cost_group_id
8694: and cost_element_id = cost_element