DBA Data[Home] [Help]

APPS.PN_MTM_ROLLFORWARD_PKG dependencies on PN_LOCATIONS_ALL

Line 442: FROM pn_locations_all

438: WHERE lease_id = p_lease_id;
439:
440: CURSOR get_loc_type_code (p_location_id NUMBER) IS
441: SELECT location_type_lookup_code
442: FROM pn_locations_all
443: WHERE location_id = p_location_id;
444:
445: CURSOR chk_conflicts(p_lease_id NUMBER,
446: p_ten_st_dt DATE,

Line 650: pn_locations_all loc,

646: var.rent_num var_rent_num
647: FROM pn_leases_all lease,
648: pn_lease_details_all lease_det,
649: pn_tenancies_all ten,
650: pn_locations_all loc,
651: pn_properties_all prop,
652: pn_index_leases_all ilease,
653: pn_var_rents_all var,
654: pn_payment_terms_all terms