APPS.PN_VAR_TRUEUP_PKG dependencies on PN_LEASES

Line 2817: pn_leases_all lease

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

Line 2832: pn_leases_all lease

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

Line 2874: FROM pn_leases;

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