APPS.FA_RSVLDG_REP_INS_PKG dependencies on FA_ADDITIONS

Line 211: FA_ADDITIONS AD,

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,
213: FA_DEPRN_PERIODS DP
214: WHERE BOOKS.BOOK_TYPE_CODE = book
215: AND BOOKS.ASSET_ID = DD_BONUS.ASSET_ID --7721457

Line 287: FA_ADDITIONS AD,

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,
289: FA_DEPRN_PERIODS DP
290: WHERE BOOKS.BOOK_TYPE_CODE = book
291: AND BOOKS.ASSET_ID = DD.ASSET_ID --7721457

Line 387: FA_ADDITIONS AD,

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,
389: FA_DEPRN_PERIODS DP
390: WHERE BOOKS.BOOK_TYPE_CODE = book
391: AND BOOKS.ASSET_ID = DD_BONUS.ASSET_ID --7721457

Line 463: FA_ADDITIONS AD,

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,
465: FA_DEPRN_PERIODS DP
466: WHERE BOOKS.BOOK_TYPE_CODE = book
467: AND BOOKS.ASSET_ID = DD.ASSET_ID --7721457

Line 562: FA_ADDITIONS AD,

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,
564: FA_DEPRN_PERIODS DP
565: WHERE BOOKS.BOOK_TYPE_CODE = book
566: AND BOOKS.ASSET_ID = DD_BONUS.ASSET_ID --7721457

Line 664: FA_ADDITIONS AD,

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,
665: FA_BONUS_RATES BR,
666: FA_DEPRN_PERIODS DP
667: WHERE BOOKS.BOOK_TYPE_CODE = book
668: AND BOOKS.ASSET_ID = DD_BONUS.ASSET_ID --7721457

Line 774: FA_ADDITIONS AD,

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,
775: FA_BONUS_RATES BR,
776: FA_DEPRN_PERIODS DP
777: WHERE books.group_asset_id IS NULL
778: AND CB.BOOK_TYPE_CODE = book

Line 878: FA_ADDITIONS AD,

874: FA_BOOKS BOOKS ,
875: FA_TRANSACTION_HEADERS TH ,
876: FA_TRANSACTION_HEADERS TH_RT,
877: FA_CATEGORY_BOOKS CB ,
878: FA_ADDITIONS AD,
879: FA_BONUS_RATES BR,
880: FA_DEPRN_PERIODS DP
881: WHERE books.group_asset_id IS NULL
882: AND CB.BOOK_TYPE_CODE = book

Line 979: FA_ADDITIONS AD,

975: FROM FA_DEPRN_SUMMARY_MRC_V DD ,
976: FA_GROUP_ASSET_RULES GAR ,
977: FA_GROUP_ASSET_DEFAULT GAD,
978: FA_DEPRN_PERIODS_MRC_V DP,
979: FA_ADDITIONS AD,
980: FA_BONUS_RATES BR
981: WHERE DD.BOOK_TYPE_CODE = book
982: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
983: AND DD.ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE

Line 1064: FA_ADDITIONS AD,

1060: FROM FA_DEPRN_SUMMARY DD ,
1061: FA_GROUP_ASSET_RULES GAR ,
1062: FA_GROUP_ASSET_DEFAULT GAD,
1063: FA_DEPRN_PERIODS DP,
1064: FA_ADDITIONS AD,
1065: FA_BONUS_RATES BR
1066: WHERE DD.BOOK_TYPE_CODE = book
1067: AND DD.ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
1068: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID

Line 1144: FA_ADDITIONS AD,

1140: fa_GROUP_ASSET_RULES GAR ,
1141: fa_GROUP_ASSET_DEFAULT GAD,
1142: fa_SUPER_GROUP_RULES SGR ,
1143: FA_DEPRN_PERIODS_MRC_V DP,
1144: FA_ADDITIONS AD,
1145: FA_BONUS_RATES BR
1146: WHERE DD.BOOK_TYPE_CODE = book
1147: AND DD.ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
1148: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID

Line 1222: FA_ADDITIONS AD,

1218: fa_GROUP_ASSET_RULES GAR ,
1219: fa_GROUP_ASSET_DEFAULT GAD,
1220: fa_SUPER_GROUP_RULES SGR ,
1221: FA_DEPRN_PERIODS DP,
1222: FA_ADDITIONS AD,
1223: FA_BONUS_RATES BR
1224: WHERE DD.BOOK_TYPE_CODE = book
1225: AND DD.ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
1226: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID