DBA Data[Home] [Help]

APPS.PN_VARIABLE_TERM_PKG dependencies on PN_LEASE_DETAILS_ALL

Line 58: pn_lease_details_all pld,

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

Line 92: pn_lease_details_all pld,

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

Line 749: pn_lease_details_all pld

745: INTO l_lease_class_code,
746: l_lease_change_id,
747: l_org_id
748: FROM pn_leases_all pl,
749: pn_lease_details_all pld
750: WHERE pl.lease_id = pld.lease_id
751: AND pld.lease_id = p_lease_id;
752:
753: EXCEPTION