DBA Data[Home] [Help]

APPS.FA_CUA_MASS_UPDATE1_PKG dependencies on FA_ADDITIONS

Line 295: from fa_additions

291: end if;
292: -- also check lease stuff
293: if X_Old_Cat_Type = 'LEASE' and X_New_Cat_Type <> 'LEASE' then
294: select count(*) into ll_count
295: from fa_additions
296: where lease_id = X_Lease_Id
297: and asset_category_id in
298: (select category_id from fa_categories
299: where category_type = 'LEASEHOLD IMPROVEMENT');

Line 357: --l_asset_rec fa_additions_v%rowtype;

353: --l_new_capitalize_flag varchar2(10);
354: --l_new_Category_Type varchar2(30);
355: --l_cat_flex_struct NUMBER;
356: --l_cat_segs FA_RX_SHARED_PKG.Seg_Array;
357: --l_asset_rec fa_additions_v%rowtype;
358:
359: --l_return_status BOOLEAN;
360: --l_return_status2 BOOLEAN;
361: --l_return_status3 BOOLEAN;

Line 467: FA_ADDITIONS A

463: DH.LOCATION_ID,
464: DH.ASSIGNED_TO
465: FROM
466: FA_HIERARCHY_DISTRIBUTIONS DH,
467: FA_ADDITIONS A
468: WHERE
469: A.ASSET_ID = p_asset_id AND
470: DH.DIST_SET_ID = p_new_hr_dist_set_id;
471: