DBA Data[Home] [Help]

APPS.FA_CUA_ASSET_WB_APIS_PKG dependencies on FA_LEASES

Line 247: v_lease_number fa_leases.lease_number%type;

243: end get_employee_number;
244:
245: Function get_lease_number (x_id in number) return varchar2 is
246:
247: v_lease_number fa_leases.lease_number%type;
248: cursor c is
249: select lease_number
250: from fa_leases
251: where lease_id = x_id;

Line 250: from fa_leases

246:
247: v_lease_number fa_leases.lease_number%type;
248: cursor c is
249: select lease_number
250: from fa_leases
251: where lease_id = x_id;
252: Begin
253: open c;
254: fetch c into v_lease_number;

Line 265: from fa_leases

261:
262: v_lease_id number ;
263: cursor c is
264: select lease_id
265: from fa_leases
266: where lease_number = x_lease_number;
267: Begin
268: open c;
269: fetch c into v_lease_id;