DBA Data[Home] [Help]

APPS.FA_ASSET_HIERARCHY_PVT dependencies on FA_ASSET_HIERARCHY_PURPOSE

Line 13: from fa_asset_hierarchy_purpose

9: l_parent_id number;
10:
11: Cursor C1 IS
12: select book_type_code
13: from fa_asset_hierarchy_purpose
14: where asset_hierarchy_purpose_id =
15: ( select asset_hierarchy_purpose_id
16: from fa_asset_hierarchy
17: where asset_hierarchy_id = p_parent_hierarchy_id

Line 52: from fa_asset_hierarchy_purpose

48: p_asset_hierarchy_rec IN FA_API_TYPES.asset_hierarchy_rec_type ) return boolean IS
49:
50: cursor C_purpose is
51: select asset_hierarchy_purpose_id
52: from fa_asset_hierarchy_purpose
53: where book_type_code = p_asset_hdr_rec.book_type_code
54: and purpose_type = 'INHERITANCE';
55:
56: l_err_stage varchar2(640);