APPS.PN_VARIABLE_TERM_PKG dependencies on PN_LEASE_DETAILS_ALL

Line 55: pn_lease_details_all pld,

51: per.period_num,
52: pl.lease_class_code,
53: pl.org_id
54: FROM pn_leases pl,
55: pn_lease_details_all pld,
56: pn_var_rents_all pvr,
57: pn_locations_all ploc,
58: pn_var_periods_all per
59: WHERE pl.lease_id = pvr.lease_id

Line 89: pn_lease_details_all pld,

85: pl.lease_class_code,
86: pl.org_id
87: FROM pn_var_rents_all pvr,
88: pn_leases pl,
89: pn_lease_details_all pld,
90: pn_var_periods_all per
91: WHERE pl.lease_id = pvr.lease_id
92: AND pld.lease_id = pvr.lease_id
93: AND pvr.var_rent_id = per.var_rent_id

Line 745: pn_lease_details_all pld

741: INTO l_lease_class_code,
742: l_lease_change_id,
743: l_org_id
744: FROM pn_leases_all pl,
745: pn_lease_details_all pld
746: WHERE pl.lease_id = pld.lease_id
747: AND pld.lease_id = p_lease_id;
748:
749: EXCEPTION