APPS.PN_VAR_RENT_PKG dependencies on PN_LEASES_ALL

Line 5347: PN_LEASES_ALL pl

5343: SELECT ppi.payment_term_id
5344: FROM PN_PAYMENT_ITEMS_ALL ppi,
5345: PN_PAYMENT_TERMS_ALL ppt,
5346: PN_VAR_RENT_INV_ALL pvri,
5347: PN_LEASES_ALL pl
5348: WHERE DECODE(pl.lease_class_code, 'DIRECT', NVL(ppi.transferred_to_ap_flag,'N'),
5349: 'THIRD_PARTY', NVL(ppi.transferred_to_ar_flag,'N'),
5350: 'SUB_LEASE', NVL(ppi.transferred_to_ar_flag,'N')) = 'N'
5351: AND ppi.payment_term_id = ppt.payment_term_id

Line 10324: FROM pn_leases_all

10320: FROM pn_locations_all
10321: WHERE property_id = p_prop_id)
10322: UNION
10323: SELECT lease_id
10324: FROM pn_leases_all
10325: WHERE location_id in (SELECT location_id
10326: FROM pn_locations_all
10327: WHERE property_id = p_prop_id)));
10328:

Line 10341: FROM pn_leases_all

10337: FROM pn_tenancies_all
10338: WHERE location_id = p_loc_id
10339: UNION
10340: SELECT lease_id
10341: FROM pn_leases_all
10342: WHERE location_id = p_loc_id));
10343:
10344:
10345: /* Cursor to get all var_rents for the given lease */