APPS.JA_AU_FA_BAL_CHG dependencies on FA_CATEGORIES

Line 29: FROM FA_Categories_B B,

25: v_col2 fnd_id_flex_segments.application_column_name%type;
26:
27: CURSOR C_Get_First_Category IS
28: SELECT B.Category_id
29: FROM FA_Categories_B B,
30: FA_Categories_TL T
31: WHERE B.category_id = T.category_id
32: AND T.language = userenv('LANG')
33: AND ROWNUM = 1;

Line 30: FA_Categories_TL T

26:
27: CURSOR C_Get_First_Category IS
28: SELECT B.Category_id
29: FROM FA_Categories_B B,
30: FA_Categories_TL T
31: WHERE B.category_id = T.category_id
32: AND T.language = userenv('LANG')
33: AND ROWNUM = 1;
34:

Line 45: FROM fa_categories C,

41: DECODE(nvl(flex2.application_column_name, ' '), 'SEGMENT7', C.SEGMENT7, 'SEGMENT6', C.SEGMENT6,
42: 'SEGMENT5', C.SEGMENT5, 'SEGMENT4', C.SEGMENT4, 'SEGMENT3',
43: C.SEGMENT3, 'SEGMENT2', C.SEGMENT2, 'SEGMENT1', C.SEGMENT1,
44: ' '))
45: FROM fa_categories C,
46: fnd_id_flexs flexid,
47: fnd_id_flex_segments flex1,
48: fnd_id_flex_segments flex2
49: WHERE C.Category_id = nvl(C_category_id,C_first_category)

Line 185: fa_categories c,

181: uid
182: from fa_books b1,
183: fa_books b2,
184: fa_additions a,
185: fa_categories c,
186: fa_methods m
187: where b1.asset_id = a.asset_id
188: and b1.book_type_code = v_book_type_code
189: and b1.date_effective =