DBA Data[Home] [Help]

APPS.PN_APPROVE_VARENT_PKG dependencies on PN_LEASE_DETAILS_ALL

Line 57: pn_lease_details_all pld,

53: pvr.rent_num,
54: pvr.invoice_on,
55: pl.status
56: FROM pn_leases pl,
57: pn_lease_details_all pld,
58: pn_var_rents_all pvr,
59: pn_locations_all ploc
60: WHERE pl.lease_id = pvr.lease_id
61: AND pld.lease_id = pvr.lease_id

Line 80: pn_lease_details_all pld

76: pvr.invoice_on,
77: pl.status
78: FROM pn_leases pl,
79: pn_var_rents_all pvr,
80: pn_lease_details_all pld
81: WHERE pl.lease_id = pvr.lease_id
82: AND pld.lease_id = pvr.lease_id
83: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)
84: AND pl.lease_num <= NVL(p_lease_num_to, pl.lease_num)