APPS.PA_AP_XFER_PKG dependencies on PA_EXPENDITURE_ITEMS

Line 32: pa_expenditure_items ei

28: CURSOR Inv_stat_cur
29: IS
30: Select distinct system_reference2
31: from pa_cost_distribution_lines cdl,
32: pa_expenditure_items ei
33: where ei.cost_distributed_flag ='S'
34: AND ei.request_id = g_request_id
35: AND ei.system_linkage_function = 'VI'
36: AND cdl.transfer_status_code = 'P'

Line 50: FROM pa_expenditure_items_all ei

46: SELECT cdl.expenditure_item_id
47: ,cdl.line_num
48: ,cdl.line_num_reversed
49: ,cdl.dr_code_combination_id
50: FROM pa_expenditure_items_all ei
51: ,pa_cost_distribution_lines_all cdl
52: WHERE ei.cost_distributed_flag = 'S'
53: AND ei.request_id = g_request_id
54: AND ei.system_linkage_function = 'VI'