DBA Data[Home] [Help]

APPS.JA_CN_FA_ACS_EXPORT_PKG dependencies on FA_BOOK_CONTROLS_SEC

Line 99: FROM fa_book_controls_sec fbcs

95: --to get the category
96: CURSOR category_cur
97: IS
98: SELECT DISTINCT fcbk.concatenated_segments category_name
99: FROM fa_book_controls_sec fbcs
100: ,fa_category_books fcb
101: ,fa_additions_v fav
102: ,fa_categories_b_kfv fcbk
103: WHERE fbcs.book_type_code = fcb.book_type_code

Line 111: FROM FA_BOOKS fb, FA_BOOK_CONTROLS_SEC sec

107: AND fav.asset_type = 'CAPITALIZED'
108: -- Choli updated, fix bug 12634759
109: AND (asset_id in
110: (SELECT asset_id
111: FROM FA_BOOKS fb, FA_BOOK_CONTROLS_SEC sec
112: WHERE fb.BOOK_TYPE_CODE = fcb.book_type_code
113: AND NVL(DISABLED_FLAG, 'N') = 'N'
114: AND transaction_header_id_out IS NULL
115: AND fb.BOOK_TYPE_CODE = sec.BOOK_TYPE_CODE))