DBA Data[Home] [Help]

APPS.AP_PO_AMT_MATCH_PKG dependencies on FA_BOOK_CONTROLS

Line 157: G_Asset_Book_Type_Code fa_book_controls.book_type_code%TYPE;

153: G_Task_ID pa_tasks.task_id%TYPE;
154: G_Expenditure_Type pa_expenditure_types.expenditure_type%TYPE;
155: G_Invoice_Date ap_invoices.invoice_date%TYPE;
156: G_Expenditure_Organization_ID pa_exp_orgs_it.organization_id%TYPE;
157: G_Asset_Book_Type_Code fa_book_controls.book_type_code%TYPE;
158: G_Asset_Category_Id mtl_system_items.asset_category_id%TYPE;
159: G_Inventory_Organization_Id financials_system_parameters.inventory_organization_id%TYPE;
160: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
161: -- Removed for bug 4277744

Line 792: FROM fa_book_controls fc

788: /*
789: BEGIN
790: SELECT book_type_code
791: INTO g_asset_book_type_code
792: FROM fa_book_controls fc
793: WHERE fc.book_class = 'CORP0RATE'
794: AND fc.set_of_books_id = g_set_of_books_id
795: AND fc.date_ineffective IS NULL;
796: EXCEPTION