APPS.PN_VAR_UPG_TRX_PKG dependencies on PN_VAR_RENT_INV_ALL

Line 156: FROM pn_var_rent_inv_all inv

152: SELECT /*+ ROWID(vr) */ vr.var_rent_id, invoice_on
153: FROM pn_var_rents_all vr
154: WHERE vr.var_rent_id = p_var_rent_id
155: AND EXISTS (SELECT 1
156: FROM pn_var_rent_inv_all inv
157: WHERE inv.var_rent_id = p_var_rent_id
158: AND rownum=1);
159:
160: /* Fetch the summary id and transaction id from respective tables */