APPS.PN_VAR_TRUEUP_PKG dependencies on PN_LEASES

Line 2815: pn_leases_all lease

2811: CURSOR get_vr_c IS
2812: SELECT
2813: vr.var_rent_id
2814: FROM
2815: pn_leases_all lease
2816: ,pn_var_rents_all vr
2817: WHERE
2818: vr.cumulative_vol = 'T' AND
2819: vr.lease_id = lease.lease_id AND

Line 2830: pn_leases_all lease

2826: CURSOR get_vr_prop_c(p_building_id IN NUMBER) IS
2827: SELECT
2828: vr.var_rent_id
2829: FROM
2830: pn_leases_all lease
2831: ,pn_var_rents_all vr
2832: WHERE
2833: vr.cumulative_vol = pn_var_rent_calc_pkg.G_CALC_TRUE_UP AND
2834: vr.lease_id = lease.lease_id AND

Line 2872: FROM pn_leases;

2868: ELSE
2869: BEGIN
2870: SELECT MAX(lease_num)
2871: INTO l_lease_num_high
2872: FROM pn_leases;
2873: EXCEPTION
2874: WHEN OTHERS THEN RAISE;
2875: END;
2876: END IF;