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)
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 484: where exists(select 1 from fa_categories

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