DBA Data[Home] [Help]

APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_LEASE_DETAILS_ALL

Line 6374: pn_lease_details_all pld,

6370: pvr.cumulative_vol,
6371: pvr.rent_num,
6372: pl.org_id
6373: FROM pn_leases pl,
6374: pn_lease_details_all pld,
6375: pn_var_rents_all pvr,
6376: pn_locations_all ploc
6377: WHERE pl.lease_id = pvr.lease_id
6378: AND pld.lease_id = pvr.lease_id

Line 6410: pn_lease_details_all pld,

6406: pvr.cumulative_vol,
6407: pvr.rent_num,
6408: pl.org_id
6409: FROM pn_leases pl,
6410: pn_lease_details_all pld,
6411: pn_var_rents_all pvr,
6412: pn_locations_all ploc
6413: WHERE pl.lease_id = pvr.lease_id
6414: AND pld.lease_id = pvr.lease_id

Line 6435: pn_lease_details_all pld

6431: pvr.rent_num,
6432: pl.org_id
6433: FROM pn_var_rents_all pvr,
6434: pn_leases pl,
6435: pn_lease_details_all pld
6436: WHERE pl.lease_id = pvr.lease_id
6437: AND pld.lease_id = pvr.lease_id
6438: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)
6439: AND pl.lease_num <= NVL(p_lease_num_to, pl.lease_num)