DBA Data[Home] [Help]

APPS.FA_LEASE_PITEMS_PKG dependencies on FA_LEASES

Line 214: FROM FA_Leases

210: SELECT Lessor_ID, Lessor_Site_ID,
211: Dist_Code_Combination_ID, Lease_Number
212: INTO V_Lessor_ID, V_Lessor_Site_ID,
213: V_Dist_Code_Combination_ID, V_Lease_Number
214: FROM FA_Leases
215: WHERE Lease_ID = P_Lease_ID;
216:
217: IF (V_Lessor_Site_ID is NULL or V_Dist_Code_Combination_ID is NULL) THEN
218:

Line 228: FROM FA_Leases WHERE Lease_ID = P_Lease_ID;

224:
225: ELSE
226:
227: SELECT Lease_Number INTO V_Lease_Number
228: FROM FA_Leases WHERE Lease_ID = P_Lease_ID;
229: V_Lessor_ID := P_Lessor_ID;
230: V_Lessor_Site_ID := P_Lessor_Site_ID;
231: V_Dist_Code_Combination_ID := P_Dist_Code_Combination_ID;
232: