APPS.PN_MASS_APPR_PKG dependencies on PN_LEASE_DETAILS_ALL

Line 281: pn_lease_details_all pld,

277: pl.lease_num s_lease_number,
278: pl.name s_lease_name
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)

Line 320: pn_lease_details_all pld

316: pl.lease_num s_lease_number,
317: pl.name s_lease_name
318: FROM pn_payment_schedules_all pps,
319: pn_leases pl,
320: pn_lease_details_all pld
321: WHERE pps.schedule_date BETWEEN NVL(p_schedule_from_date, pps.schedule_date)
322: AND NVL(p_schedule_to_date, pps.schedule_date)
323: AND pps.payment_status_lookup_code = 'DRAFT'
324: AND pl.lease_id = pps.lease_id

Line 874: pn_lease_details_all pld,

870: pps.schedule_date s_schedule_date,
871: pl.lease_id s_lease_id
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)

Line 910: pn_lease_details_all pld

906: pps.schedule_date s_schedule_date,
907: pl.lease_id s_lease_id
908: FROM pn_payment_schedules_all pps,
909: pn_leases pl,
910: pn_lease_details_all pld
911: WHERE pps.schedule_date BETWEEN NVL(p_schedule_from_date, pps.schedule_date)
912: AND NVL(p_schedule_to_date, pps.schedule_date)
913: AND pps.payment_status_lookup_code = 'APPROVED'
914: AND pl.lease_id = pps.lease_id