199: l_ae_txn_rec.txn_src_type_id = 5) THEN
200: l_stmt_num := 27;
201: SELECT entity_type
202: INTO l_ae_txn_rec.wip_entity_type
203: FROM wip_entities we
204: WHERE we.wip_entity_id = l_ae_txn_rec.txn_src_id;
205:
206: ELSE
207:
363: wt.transaction_id = i_transaction_id;
364:
365: SELECT entity_type
366: INTO l_ae_txn_rec.wip_entity_type
367: FROM wip_entities we
368: WHERE we.wip_entity_id = l_ae_txn_rec.txn_src_id;
369:
370: if (l_ae_txn_rec.exp_item = 1) then
371: select
8523: we.wip_entity_id
8524: into
8525: l_ae_line_rec.wip_entity_id
8526: from wip_transactions wt,
8527: wip_entities we
8528: where we.wip_entity_id = wt.wip_entity_id
8529: and wt.transaction_id = i_ae_txn_rec.transaction_id;
8530:
8531: /* Check if there are Cost Details. */
8984: into l_entity_type,
8985: l_wip_entity_id,
8986: l_line_id
8987: from wip_transactions wt,
8988: wip_entities we
8989: where we.wip_entity_id = wt.wip_entity_id
8990: and wt.transaction_id = i_ae_txn_rec.transaction_id;
8991:
8992: IF g_debug_flag = 'Y' THEN