[Home] [Help]
APPS.PN_VAR_UPG_TRX_PKG dependencies on PN_LEASES_ALL
Line 74: pn_leases_all pl
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)
78: AND pvr.rent_num >= NVL(p_vrent_num_from,pvr.rent_num)