DBA Data[Home] [Help]

APPS.FA_RSVLDG_REP_INS_PKG dependencies on FA_BONUS_RATES

Line 212: FA_BONUS_RATES BR,

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
216: AND BOOKS.ASSET_ID = AD.ASSET_ID

Line 288: FA_BONUS_RATES BR,

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
292: AND BOOKS.ASSET_ID = AD.ASSET_ID

Line 388: FA_BONUS_RATES BR,

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
392: AND BOOKS.ASSET_ID = AD.ASSET_ID

Line 464: FA_BONUS_RATES BR,

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
468: AND BOOKS.ASSET_ID = AD.ASSET_ID

Line 563: FA_BONUS_RATES BR,

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
567: AND BOOKS.ASSET_ID = AD.ASSET_ID

Line 665: FA_BONUS_RATES BR,

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
669: AND BOOKS.ASSET_ID = AD.ASSET_ID

Line 775: FA_BONUS_RATES BR,

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
779: AND CB.CATEGORY_ID = AH.CATEGORY_ID

Line 879: FA_BONUS_RATES BR,

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
883: AND CB.CATEGORY_ID = AH.CATEGORY_ID

Line 980: FA_BONUS_RATES BR

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
984: AND DD.ASSET_ID = AD.ASSET_ID

Line 1065: FA_BONUS_RATES BR

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
1069: AND DD.ASSET_ID = AD.ASSET_ID

Line 1145: FA_BONUS_RATES BR

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
1149: AND DD.ASSET_ID = AD.ASSET_ID

Line 1223: FA_BONUS_RATES BR

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
1227: AND DD.ASSET_ID = AD.ASSET_ID