APPS.PA_EXPENDITURE_INQUIRY dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 87: l_exp_id pa_expenditure_items_all.expenditure_id%type;

83: and cdl.line_num (+) = 1
84: /* Added the getNumericString wrapper over systeem_reference1 for bug3158748 */
85: and pa_utils4.getNumericString(cdl.system_reference1) = vend.vendor_id (+) ;
86: /* Start: Added temp variables for bug 7283824 */
87: l_exp_id pa_expenditure_items_all.expenditure_id%type;
88: l_vendor_id po_vendors.vendor_id%type;
89: l_system_reference2 pa_cost_dist_lines_all_bas.system_reference2%type;
90: l_vendor_name po_vendors.vendor_name%type;
91: l_vendor_number po_vendors.segment1%type;

Line 129: from pa_expenditure_items_all

125:
126: else
127:
128: select expenditure_id into l_exp_id
129: from pa_expenditure_items_all
130: where
131: expenditure_item_id=p_expenditure_item_id;
132:
133: select po.vendor_id,po.vendor_name,po.segment1