APPS.FA_RSVLDG_REP_INS_PKG dependencies on FA_BOOKS

Line 97: From FA_Books

93: /* Bugfix 6677528 : query should have more conditions. Use exists instead of count */
94:
95: /* Select count(*)
96: Into bonus_count
97: From FA_Books
98: Where book_type_code = book;
99: */
100: BEGIN
101: Select 1

Line 104: where exists (select 1 from FA_Books

100: BEGIN
101: Select 1
102: Into bonus_count
103: From dual
104: where exists (select 1 from FA_Books
105: Where book_type_code = book
106: and bonus_rule is not null
107: and transaction_header_id_out is null);
108: EXCEPTION

Line 172: FA_BOOKS_MRC_V BOOKS,

168: FROM
169: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,
170: FA_ASSET_HISTORY AH,
171: FA_TRANSACTION_HEADERS TH_RT,
172: FA_BOOKS_MRC_V BOOKS,
173: FA_DISTRIBUTION_HISTORY DH,
174: FA_CATEGORY_BOOKS CB,
175: (
176: SELECT COST,

Line 251: FA_BOOKS_MRC_V BOOKS,

247: FROM
248: --FA_DEPRN_DETAIL_MRC_V DD,
249: FA_ASSET_HISTORY AH,
250: FA_TRANSACTION_HEADERS TH_RT,
251: FA_BOOKS_MRC_V BOOKS,
252: FA_DISTRIBUTION_HISTORY DH,
253: FA_CATEGORY_BOOKS CB,
254: (
255: SELECT COST,

Line 361: FA_BOOKS BOOKS,

357: FA_ASSET_HISTORY AH,
358: FA_TRANSACTION_HEADERS TH_RT,
359: FA_DISTRIBUTION_HISTORY DH,
360: FA_CATEGORY_BOOKS CB,
361: FA_BOOKS BOOKS,
362: (
363: SELECT COST,
364: PERIOD_COUNTER,
365: DEPRN_AMOUNT,

Line 440: FA_BOOKS BOOKS,

436: FA_ASSET_HISTORY AH,
437: FA_TRANSACTION_HEADERS TH_RT,
438: FA_DISTRIBUTION_HISTORY DH,
439: FA_CATEGORY_BOOKS CB,
440: FA_BOOKS BOOKS,
441: (
442: SELECT COST,
443: PERIOD_COUNTER,
444: DEPRN_AMOUNT,

Line 552: FA_BOOKS_MRC_V BOOKS,

548: FROM
549: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,
550: FA_ASSET_HISTORY AH,
551: FA_TRANSACTION_HEADERS TH_RT,
552: FA_BOOKS_MRC_V BOOKS,
553: FA_DISTRIBUTION_HISTORY DH,
554: FA_CATEGORY_BOOKS CB,
555: (
556: SELECT COST,

Line 662: FA_BOOKS BOOKS,

658: FA_ASSET_HISTORY AH,
659: FA_TRANSACTION_HEADERS TH_RT,
660: FA_DISTRIBUTION_HISTORY DH,
661: FA_CATEGORY_BOOKS CB,
662: FA_BOOKS BOOKS,
663: (
664: SELECT COST,
665: PERIOD_COUNTER,
666: DEPRN_AMOUNT,

Line 773: FA_BOOKS_MRC_V BOOKS,

769: --FA_DEPRN_DETAIL_MRC_V DD,
770: FA_ASSET_HISTORY AH,
771: FA_TRANSACTION_HEADERS TH,
772: FA_TRANSACTION_HEADERS TH_RT,
773: FA_BOOKS_MRC_V BOOKS,
774: FA_DISTRIBUTION_HISTORY DH,
775: FA_CATEGORY_BOOKS CB,
776: (
777: SELECT COST,

Line 886: FA_BOOKS BOOKS,

882: --FA_DEPRN_DETAIL DD,
883: FA_ASSET_HISTORY AH,
884: FA_TRANSACTION_HEADERS TH,
885: FA_TRANSACTION_HEADERS TH_RT,
886: FA_BOOKS BOOKS,
887: FA_DISTRIBUTION_HISTORY DH,
888: FA_CATEGORY_BOOKS CB,
889: (
890: SELECT COST,