DBA Data[Home] [Help]

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 1163: fa_book_controls bc

1159: SELECT fy.fiscal_year
1160: INTO X_prorate_fiscal_year
1161: FROM fa_calendar_periods cp,
1162: fa_fiscal_year fy,
1163: fa_book_controls bc
1164: WHERE fy.fiscal_year_name = bc.fiscal_year_name
1165: AND cp.calendar_type = bc.prorate_calendar
1166: AND bc.book_type_code = PARM.p_book_type_code
1167: AND JG_RX_FAREG.var.prorate_date between

Line 1278: fa_book_controls fabc

1274: vendor_name
1275: into JG_RX_FAREG.var.invoice_number,
1276: JG_RX_FAREG.var.supplier_name
1277: from fa_asset_invoices ai,po_vendors ve,fa_invoice_transactions IT,
1278: fa_book_controls fabc
1279: where ai.po_vendor_id= ve.vendor_id and
1280: ai.asset_id = JG_RX_FAREG.var.asset_id and
1281: ai.invoice_transaction_id_in = IT.invoice_transaction_id and
1282: -- IT.book_type_code = PARM.p_book_type_code;

Line 2332: fa_book_controls BC

2328: X_fiscal_year_end_date,
2329: X_deprn_calendar,
2330: X_prorate_calendar
2331: FROM fa_fiscal_year FY,
2332: fa_book_controls BC
2333: WHERE FY.fiscal_year = X_fiscal_year
2334: AND FY.fiscal_year_name = BC.fiscal_year_name
2335: AND BC.book_type_code = PARM.p_book_type_code;
2336: