[Home] [Help]
8073: l_cost_group_id number ,
8074: l_cost_element number)
8075: IS
8076: select distinct resource_id /* added distinct for bug 3116821 */
8077: from wip_pac_actual_cost_details
8078: where transaction_id = l_transaction_id
8079: and pac_period_id = l_accounting_period_id
8080: and cost_group_id = l_cost_group_id
8081: and cost_element_id = l_cost_element;
8122: -- --------------------------------
8123: l_stmt_num := 20;
8124: select count(transaction_id)
8125: into l_ele_exist
8126: from wip_pac_actual_cost_details mpacd
8127: where mpacd.transaction_id = i_ae_txn_rec.transaction_id
8128: and mpacd.pac_period_id = i_ae_txn_rec.accounting_period_id
8129: and mpacd.cost_group_id = i_ae_txn_rec.cost_group_id
8130: and rownum < 2; /* 4586534 added rownum filter for perf as its only existence check */
8151: SELECT nvl(actual_value ,0) ,
8152: nvl(actual_cost ,0)
8153: INTO l_actual_value,
8154: l_actual_cost
8155: FROM wip_pac_actual_cost_details
8156: WHERE transaction_id = i_ae_txn_rec.transaction_id
8157: AND pac_period_id = i_ae_txn_rec.accounting_period_id
8158: AND cost_group_id = i_ae_txn_rec.cost_group_id;
8159:
8288: select sum(nvl(actual_value,0)),
8289: sum(nvl(actual_cost,0))
8290: into l_actual_value,
8291: l_actual_cost
8292: from wip_pac_actual_cost_details
8293: where transaction_id = i_ae_txn_rec.transaction_id
8294: and pac_period_id = i_ae_txn_rec.accounting_period_id
8295: and cost_group_id = i_ae_txn_rec.cost_group_id
8296: and cost_element_id = cost_element
8300: select nvl(actual_value ,0) ,
8301: nvl(actual_cost ,0)
8302: into l_actual_value,
8303: l_actual_cost
8304: from wip_pac_actual_cost_details
8305: where transaction_id = i_ae_txn_rec.transaction_id
8306: and pac_period_id = i_ae_txn_rec.accounting_period_id
8307: and cost_group_id = i_ae_txn_rec.cost_group_id
8308: and cost_element_id = cost_element