APPS.FA_RSVLDG_REP_INS_PKG dependencies on FA_BOOKS

Line 108: where exists (select 1 from FA_Books

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

Line 208: FA_BOOKS_MRC_V BOOKS ,

204: ) dd1,
205: FA_DEPRN_DETAIL_MRC_V DD_BONUS,
206: FA_DISTRIBUTION_HISTORY DH ,
207: FA_ASSET_HISTORY AH ,
208: FA_BOOKS_MRC_V BOOKS ,
209: FA_TRANSACTION_HEADERS TH_RT,
210: FA_CATEGORY_BOOKS CB,
211: FA_ADDITIONS AD,
212: FA_BONUS_RATES BR,

Line 284: FA_BOOKS_MRC_V BOOKS ,

280: ) dd1,
281: FA_DEPRN_DETAIL_MRC_V DD,
282: FA_DISTRIBUTION_HISTORY DH ,
283: FA_ASSET_HISTORY AH ,
284: FA_BOOKS_MRC_V BOOKS ,
285: FA_TRANSACTION_HEADERS TH_RT,
286: FA_CATEGORY_BOOKS CB,
287: FA_ADDITIONS AD,
288: FA_BONUS_RATES BR,

Line 384: FA_BOOKS BOOKS ,

380: ) DD1 ,
381: FA_DEPRN_DETAIL DD_BONUS ,
382: FA_DISTRIBUTION_HISTORY DH ,
383: FA_ASSET_HISTORY AH ,
384: FA_BOOKS BOOKS ,
385: FA_TRANSACTION_HEADERS TH_RT,
386: FA_CATEGORY_BOOKS CB ,
387: FA_ADDITIONS AD,
388: FA_BONUS_RATES BR,

Line 460: FA_BOOKS BOOKS ,

456: ) DD1,
457: FA_DEPRN_DETAIL DD ,
458: FA_DISTRIBUTION_HISTORY DH ,
459: FA_ASSET_HISTORY AH ,
460: FA_BOOKS BOOKS ,
461: FA_TRANSACTION_HEADERS TH_RT,
462: FA_CATEGORY_BOOKS CB ,
463: FA_ADDITIONS AD,
464: FA_BONUS_RATES BR,

Line 559: FA_BOOKS_MRC_V BOOKS ,

555: ) dd1,
556: FA_DEPRN_DETAIL_MRC_V DD_BONUS,
557: FA_DISTRIBUTION_HISTORY DH ,
558: FA_ASSET_HISTORY AH ,
559: FA_BOOKS_MRC_V BOOKS ,
560: FA_TRANSACTION_HEADERS TH_RT,
561: FA_CATEGORY_BOOKS CB,
562: FA_ADDITIONS AD,
563: FA_BONUS_RATES BR,

Line 660: FA_BOOKS BOOKS ,

656: ) DD1,
657: FA_DEPRN_DETAIL DD_BONUS ,
658: FA_DISTRIBUTION_HISTORY DH ,
659: FA_ASSET_HISTORY AH ,
660: FA_BOOKS BOOKS ,
661: FA_TRANSACTION_HEADERS TH_RT,
662: FA_TRANSACTION_HEADERS TH_DIST_END,
663: FA_CATEGORY_BOOKS CB ,
664: FA_ADDITIONS AD,

Line 770: FA_BOOKS_MRC_V BOOKS ,

766: ) dd1,
767: FA_DEPRN_DETAIL_MRC_V DD ,
768: FA_DISTRIBUTION_HISTORY DH ,
769: FA_ASSET_HISTORY AH ,
770: FA_BOOKS_MRC_V BOOKS ,
771: FA_TRANSACTION_HEADERS TH ,
772: FA_TRANSACTION_HEADERS TH_RT,
773: FA_CATEGORY_BOOKS CB ,
774: FA_ADDITIONS AD,

Line 874: FA_BOOKS BOOKS ,

870: ) DD1,
871: FA_DEPRN_DETAIL DD ,
872: FA_DISTRIBUTION_HISTORY DH ,
873: FA_ASSET_HISTORY AH ,
874: FA_BOOKS BOOKS ,
875: FA_TRANSACTION_HEADERS TH ,
876: FA_TRANSACTION_HEADERS TH_RT,
877: FA_CATEGORY_BOOKS CB ,
878: FA_ADDITIONS AD,