DBA Data[Home] [Help]

APPS.PN_VARIABLE_AMOUNT_PKG dependencies on PN_LEASE_DETAILS_ALL

Line 2302: pn_lease_details_all pld,

2298: pvr.cumulative_vol,
2299: pvr.rent_num,
2300: pl.org_id
2301: FROM pn_leases pl,
2302: pn_lease_details_all pld,
2303: pn_var_rents_all pvr,
2304: pn_locations_all ploc
2305: WHERE pl.lease_id = pvr.lease_id
2306: AND pld.lease_id = pvr.lease_id

Line 2327: pn_lease_details_all pld

2323: pvr.rent_num,
2324: pl.org_id
2325: FROM pn_var_rents_all pvr,
2326: pn_leases pl,
2327: pn_lease_details_all pld
2328: WHERE pl.lease_id = pvr.lease_id
2329: AND pld.lease_id = pvr.lease_id
2330: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)
2331: AND pl.lease_num <= NVL(p_lease_num_to, pl.lease_num)