DBA Data[Home] [Help]

APPS.HXC_RDB_RECIPIENT_SNAPSHOT dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 14: pa_expenditure_items_all pa,

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

Line 28: pa_expenditure_items_all pa,

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