APPS.FA_CUA_HIERARCHY_PKG dependencies on FA_CATEGORIES

Line 34: from fa_categories

30: ,x_err_stage in out nocopy varchar2
31: ,x_err_stack in out nocopy varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
32: is
33: Cursor C_1 is select category_type
34: from fa_categories
35: where category_id = x_asset_category_id;
36:
37: Cursor C_2 is select 1
38: from fa_category_books

Line 42: l_category_type FA_CATEGORIES.category_type%TYPE;

38: from fa_category_books
39: where category_id = x_asset_category_id
40: and book_type_code = x_book_type_code;
41:
42: l_category_type FA_CATEGORIES.category_type%TYPE;
43: dummy C_2%ROWTYPE;
44: l_old_err_stack varchar2(640);
45: Begin
46: l_old_err_stack := x_err_stack;

Line 487: where exists(select 1 from fa_categories

483: is
484: dummy number;
485: begin
486: select 1 into dummy from dual
487: where exists(select 1 from fa_categories
488: where category_id = x_catg_id
489: and category_type = 'NON-LEASE');
490: return(TRUE);
491: exception