APPS.FA_CUA_MASS_UPDATE1_PKG dependencies on FA_ADDITIONS

Line 297: from fa_additions

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

Line 359: --l_asset_rec fa_additions_v%rowtype;

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

Line 469: FA_ADDITIONS A

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