DBA Data[Home] [Help]

APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_LEASES

Line 6415: FROM pn_leases pl,

6411: pvr.invoice_on,
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

Line 6451: FROM pn_leases pl,

6447: pvr.invoice_on,
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

Line 6476: pn_leases pl,

6472: pvr.cumulative_vol,
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)