APPS.PN_VAR_UPG_TRX_PKG dependencies on PN_VAR_LINES_ALL

Line 197: UPDATE pn_var_lines_all

193: IF var_rent_rec.invoice_on = 'FORECASTED' THEN
194:
195: /* after populating the sales, sales_vol_update_flag becomes NULL.
196: Therefore need to set it to 'Y' so that forecasted sales get populated */
197: UPDATE pn_var_lines_all
198: SET sales_vol_update_flag = 'Y'
199: WHERE var_rent_id = p_var_rent_id;
200:
201: pn_var_trx_pkg.populate_sales_for(p_var_rent_id => p_var_rent_id);