10: IS SELECT pa.expenditure_item_id,
11: exp.expenditure_group,
12: ROWIDTOCHAR(ret.rowid)
13: FROM hxc_ret_pa_latest_details ret,
14: pa_expenditure_items_all pa,
15: pa_expenditures_all exp
16: WHERE ret.request_id = p_request_id
17: AND pa.transaction_source = 'ORACLE TIME AND LABOR'
18: AND pa.orig_transaction_reference = ret.time_building_block_id||':'||ret.object_version_number
24: IS SELECT pa.expenditure_item_id,
25: exp.expenditure_group,
26: ROWIDTOCHAR(ret.rowid)
27: FROM hxc_ret_pa_latest_details ret,
28: pa_expenditure_items_all pa,
29: pa_expenditures_all exp
30: WHERE ret.request_id = p_request_id
31: AND pa.transaction_source = 'ORACLE TIME AND LABOR'
32: AND pa.orig_transaction_reference = ret.time_building_block_id||':'||ret.object_version_number