APPS.PN_VAR_RENT_PKG dependencies on PN_LEASES_ALL

Line 5343: PN_LEASES_ALL pl

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

Line 10307: FROM pn_leases_all

10303: FROM pn_locations_all
10304: WHERE property_id = p_prop_id)
10305: UNION
10306: SELECT lease_id
10307: FROM pn_leases_all
10308: WHERE location_id in (SELECT location_id
10309: FROM pn_locations_all
10310: WHERE property_id = p_prop_id)));
10311:

Line 10324: FROM pn_leases_all

10320: FROM pn_tenancies_all
10321: WHERE location_id = p_loc_id
10322: UNION
10323: SELECT lease_id
10324: FROM pn_leases_all
10325: WHERE location_id = p_loc_id));
10326:
10327:
10328: /* Cursor to get all var_rents for the given lease */