APPS.FARX_AL dependencies on FA_BOOK_CONTROLS

Line 167: from fa_book_controls

163: if h_sob_id <> -1999 then
164: begin
165: select 'P'
166: into H_MRCSOBTYPE
167: from fa_book_controls
168: where book_type_code = h_book
169: and set_of_books_id = h_sob_id;
170: exception
171: when others then

Line 209: FROM FA_BOOK_CONTROLS BC,

205: h_fy_name,
206: h_chart_of_accounts_id,
207: h_organization_name,
208: h_set_of_books_id
209: FROM FA_BOOK_CONTROLS BC,
210: GL_SETS_OF_BOOKS SOB
211: WHERE BC.BOOK_TYPE_CODE = h_book
212: AND SOB.SET_OF_BOOKS_ID = BC.SET_OF_BOOKS_ID;
213: else

Line 226: FROM FA_BOOK_CONTROLS_mrc_v BC,

222: h_fy_name,
223: h_chart_of_accounts_id,
224: h_organization_name,
225: h_set_of_books_id
226: FROM FA_BOOK_CONTROLS_mrc_v BC,
227: GL_SETS_OF_BOOKS SOB
228: WHERE BC.BOOK_TYPE_CODE = h_book
229: AND SOB.SET_OF_BOOKS_ID = BC.SET_OF_BOOKS_ID;
230: END if;

Line 392: FA_BOOK_CONTROLS BC -- Added for bug#2675646

388: PER_PEOPLE_F EMP,
389: FA_ADDITIONS AD,
390: FA_CATEGORIES CAT,
391: FA_CATEGORY_BOOK_DEFAULTS CBD,
392: FA_BOOK_CONTROLS BC -- Added for bug#2675646
393: WHERE
394: CB.BOOK_TYPE_CODE = :h_book AND
395: CB.CATEGORY_ID = AH.CATEGORY_ID
396: AND

Line 459: FA_BOOK_CONTROLS_mrc_v BC -- Added for bug#2675646

455: PER_PEOPLE_F EMP,
456: FA_ADDITIONS AD,
457: FA_CATEGORIES CAT,
458: FA_CATEGORY_BOOK_DEFAULTS CBD,
459: FA_BOOK_CONTROLS_mrc_v BC -- Added for bug#2675646
460: WHERE
461: CB.BOOK_TYPE_CODE = :h_book AND
462: CB.CATEGORY_ID = AH.CATEGORY_ID
463: AND

Line 682: FA_BOOK_CONTROLS BC -- Added for Bug#2675646

678: DH.UNITS_ASSIGNED UNITS
679: FROM
680: FA_DEPRN_DETAIL DD,
681: FA_DISTRIBUTION_HISTORY DH,
682: FA_BOOK_CONTROLS BC -- Added for Bug#2675646
683: WHERE
684: DD.ASSET_ID = h_asset_id AND
685: DD.BOOK_TYPE_CODE = h_book AND
686: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND

Line 715: FA_BOOK_CONTROLS BC -- Added for Bug#2675646

711: FROM
712: FA_DEPRN_DETAIL DD,
713: FA_DISTRIBUTION_HISTORY DH,
714: FA_DISTRIBUTION_HISTORY DH_PRIOR,
715: FA_BOOK_CONTROLS BC -- Added for Bug#2675646
716: WHERE
717: DD.ASSET_ID = h_asset_id AND
718: DD.BOOK_TYPE_CODE = h_book AND
719: DD.DISTRIBUTION_ID = DH_PRIOR.DISTRIBUTION_ID AND

Line 760: FA_BOOK_CONTROLS BC -- Added for Bug#2675646

756: FROM
757: FA_ADJUSTMENTS ADJ,
758: FA_LOOKUPS LU,
759: FA_DISTRIBUTION_HISTORY DH,
760: FA_BOOK_CONTROLS BC -- Added for Bug#2675646
761: WHERE
762: LU.LOOKUP_TYPE = 'JOURNAL ENTRIES' AND
763: ((ADJ.ADJUSTMENT_TYPE IN ('COST','CIP COST') AND
764: LU.LOOKUP_CODE = 'ADDITION COST')

Line 809: FA_BOOK_CONTROLS_mrc_v BC -- Added for Bug#2675646

805: DH.UNITS_ASSIGNED UNITS
806: FROM
807: FA_DEPRN_DETAIL_mrc_v DD,
808: FA_DISTRIBUTION_HISTORY DH,
809: FA_BOOK_CONTROLS_mrc_v BC -- Added for Bug#2675646
810: WHERE
811: DD.ASSET_ID = h_asset_id AND
812: DD.BOOK_TYPE_CODE = h_book AND
813: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND

Line 842: FA_BOOK_CONTROLS_mrc_v BC -- Added for Bug#2675646

838: FROM
839: FA_DEPRN_DETAIL_mrc_v DD,
840: FA_DISTRIBUTION_HISTORY DH,
841: FA_DISTRIBUTION_HISTORY DH_PRIOR,
842: FA_BOOK_CONTROLS_mrc_v BC -- Added for Bug#2675646
843: WHERE
844: DD.ASSET_ID = h_asset_id AND
845: DD.BOOK_TYPE_CODE = h_book AND
846: DD.DISTRIBUTION_ID = DH_PRIOR.DISTRIBUTION_ID AND

Line 887: FA_BOOK_CONTROLS_mrc_v BC -- Added for Bug#2675646

883: FROM
884: FA_ADJUSTMENTS_mrc_v ADJ,
885: FA_LOOKUPS LU,
886: FA_DISTRIBUTION_HISTORY DH,
887: FA_BOOK_CONTROLS_mrc_v BC -- Added for Bug#2675646
888: WHERE
889: LU.LOOKUP_TYPE = 'JOURNAL ENTRIES' AND
890: ((ADJ.ADJUSTMENT_TYPE IN ('COST','CIP COST') AND
891: LU.LOOKUP_CODE = 'ADDITION COST')