DBA Data[Home] [Help]

APPS.PN_MASS_APPR_PKG dependencies on PN_LOCATIONS_ALL

Line 283: pn_locations_all ploc

279: FROM pn_payment_schedules_all pps,
280: pn_leases pl,
281: pn_lease_details_all pld,
282: pn_tenancies_all pt,
283: pn_locations_all ploc
284: WHERE pps.schedule_date BETWEEN NVL(p_schedule_from_date, pps.schedule_date)
285: AND NVL(p_schedule_to_date, pps.schedule_date)
286: AND pps.payment_status_lookup_code = 'DRAFT'
287: AND pl.lease_id = pps.lease_id

Line 876: pn_locations_all ploc

872: FROM pn_payment_schedules_all pps,
873: pn_leases pl,
874: pn_lease_details_all pld,
875: pn_tenancies_all pt,
876: pn_locations_all ploc
877: WHERE pps.schedule_date BETWEEN NVL(p_schedule_from_date, pps.schedule_date)
878: AND NVL(p_schedule_to_date, pps.schedule_date)
879: AND pps.payment_status_lookup_code = 'APPROVED'
880: AND pl.lease_id = pps.lease_id