DBA Data[Home] [Help]

APPS.PN_MTM_ROLLFORWARD_PKG dependencies on PN_LOCATIONS_ALL

Line 494: FROM pn_locations_all

490: WHERE lease_id = p_lease_id;
491:
492: CURSOR get_loc_type_code (p_location_id NUMBER) IS
493: SELECT location_type_lookup_code
494: FROM pn_locations_all
495: WHERE location_id = p_location_id;
496:
497: CURSOR chk_conflicts(p_lease_id NUMBER,
498: p_ten_st_dt DATE,

Line 703: pn_locations_all loc,

699: var.rent_num var_rent_num
700: FROM pn_leases_all lease,
701: pn_lease_details_all lease_det,
702: pn_tenancies_all ten,
703: pn_locations_all loc,
704: pn_properties_all prop,
705: pn_index_leases_all ilease,
706: pn_var_rents_all var,
707: pn_payment_terms_all terms