APPS.FA_LEASE_PITEMS_PKG dependencies on FA_LEASES

Line 221: FROM FA_Leases

217: SELECT Lessor_ID, Lessor_Site_ID,
218: Dist_Code_Combination_ID, Lease_Number
219: INTO V_Lessor_ID, V_Lessor_Site_ID,
220: V_Dist_Code_Combination_ID, V_Lease_Number
221: FROM FA_Leases
222: WHERE Lease_ID = P_Lease_ID;
223:
224: IF (V_Lessor_Site_ID is NULL or V_Dist_Code_Combination_ID is NULL) THEN
225:

Line 235: FROM FA_Leases WHERE Lease_ID = P_Lease_ID;

231:
232: ELSE
233:
234: SELECT Lease_Number INTO V_Lease_Number
235: FROM FA_Leases WHERE Lease_ID = P_Lease_ID;
236: V_Lessor_ID := P_Lessor_ID;
237: V_Lessor_Site_ID := P_Lessor_Site_ID;
238: V_Dist_Code_Combination_ID := P_Dist_Code_Combination_ID;
239: