DBA Data[Home] [Help]

APPS.PA_EXPENDITURE_INQUIRY dependencies on PA_UTILS4

Line 85: and pa_utils4.getNumericString(cdl.system_reference1) = vend.vendor_id (+) ;

81: PA_COST_DIST_LINES_ALL_BAS cdl
82: where cdl.expenditure_item_id = p_expenditure_item_id
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;