APPS.PN_VAR_UPG_TRX_PKG dependencies on PN_VAR_RENTS_ALL

Line 32: pn_var_rents_all pvr,

28:
29: CURSOR csr_get_vrent_wprop IS
30: SELECT pvr.var_rent_id
31: FROM pn_leases pl,
32: pn_var_rents_all pvr,
33: pn_locations_all ploc
34: WHERE pl.lease_id = pvr.lease_id
35: AND ploc.location_id = pvr.location_id
36: AND ploc.location_id IN (SELECT location_id

Line 59: pn_var_rents_all pvr,

55:
56: CURSOR csr_get_vrent_wloc IS
57: SELECT pvr.var_rent_id
58: FROM pn_leases pl,
59: pn_var_rents_all pvr,
60: pn_locations_all ploc
61: WHERE pl.lease_id = pvr.lease_id
62: AND ploc.location_id = pvr.location_id
63: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)

Line 73: FROM pn_var_rents_all pvr,

69: ORDER BY pl.lease_id, pvr.var_rent_id;
70:
71: CURSOR csr_get_vrent_woloc IS
72: SELECT pvr.var_rent_id
73: FROM pn_var_rents_all pvr,
74: pn_leases_all pl
75: WHERE pl.lease_id = pvr.lease_id
76: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)
77: AND pl.lease_num <= NVL(p_lease_num_to, pl.lease_num)

Line 153: FROM pn_var_rents_all vr

149:
150: /* Check if invoices exist for this agreement */
151: CURSOR var_rent_cur IS
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