APPS.JG_RX_FAREG dependencies on FA_BOOK_CONTROLS

Line 792: fa_book_controls bkc

788:
789: select sob.chart_of_accounts_id
790: into X_id_flex_num
791: from gl_sets_of_books sob,
792: fa_book_controls bkc
793: where bkc.book_type_code = PARM.p_Book_type_code and
794: bkc.set_of_books_id = sob.set_of_books_id;
795:
796: X_ret := FND_FLEX_APIS.get_segment_column(

Line 1170: fa_book_controls bc

1166: SELECT fy.fiscal_year
1167: INTO X_prorate_fiscal_year
1168: FROM fa_calendar_periods cp,
1169: fa_fiscal_year fy,
1170: fa_book_controls bc
1171: WHERE fy.fiscal_year_name = bc.fiscal_year_name
1172: AND cp.calendar_type = bc.prorate_calendar
1173: AND bc.book_type_code = PARM.p_book_type_code
1174: AND JG_RX_FAREG.var.prorate_date between

Line 1286: fa_book_controls fabc

1282: CURSOR c_invoice_supplier IS
1283: select substr(invoice_number,1,79) ||' ' invoice_number,
1284: substr(vendor_name,1,79) ||' ' vendor_name
1285: from fa_asset_invoices ai,po_vendors ve,fa_invoice_transactions IT,
1286: fa_book_controls fabc
1287: where ai.po_vendor_id= ve.vendor_id and
1288: ai.asset_id = JG_RX_FAREG.var.asset_id and
1289: ai.invoice_transaction_id_in = IT.invoice_transaction_id and
1290: -- IT.book_type_code = PARM.p_book_type_code;

Line 2348: fa_book_controls BC

2344: X_fiscal_year_end_date,
2345: X_deprn_calendar,
2346: X_prorate_calendar
2347: FROM fa_fiscal_year FY,
2348: fa_book_controls BC
2349: WHERE FY.fiscal_year = X_fiscal_year
2350: AND FY.fiscal_year_name = BC.fiscal_year_name
2351: AND BC.book_type_code = PARM.p_book_type_code;
2352: