DBA Data[Home] [Help]

APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_LEASE_DETAILS_ALL

Line 6416: pn_lease_details_all pld,

6412: pvr.cumulative_vol,
6413: pvr.rent_num,
6414: pl.org_id
6415: FROM pn_leases pl,
6416: pn_lease_details_all pld,
6417: pn_var_rents_all pvr,
6418: pn_locations_all ploc
6419: WHERE pl.lease_id = pvr.lease_id
6420: AND pld.lease_id = pvr.lease_id

Line 6452: pn_lease_details_all pld,

6448: pvr.cumulative_vol,
6449: pvr.rent_num,
6450: pl.org_id
6451: FROM pn_leases pl,
6452: pn_lease_details_all pld,
6453: pn_var_rents_all pvr,
6454: pn_locations_all ploc
6455: WHERE pl.lease_id = pvr.lease_id
6456: AND pld.lease_id = pvr.lease_id

Line 6477: pn_lease_details_all pld

6473: pvr.rent_num,
6474: pl.org_id
6475: FROM pn_var_rents_all pvr,
6476: pn_leases pl,
6477: pn_lease_details_all pld
6478: WHERE pl.lease_id = pvr.lease_id
6479: AND pld.lease_id = pvr.lease_id
6480: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)
6481: AND pl.lease_num <= NVL(p_lease_num_to, pl.lease_num)