[Home] [Help]
178: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;
179: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;
180: G_Project_ID pa_projects_all.project_id%TYPE;
181: G_Task_ID pa_tasks.task_id%TYPE;
182: G_Award_ID po_distributions_all.award_id%TYPE;
183: G_Expenditure_Type pa_expenditure_types.expenditure_type%TYPE;
184: G_Invoice_Date ap_invoices.invoice_date%TYPE;
185: G_Expenditure_Organization_ID pa_exp_orgs_it.organization_id%TYPE;
186: G_Asset_Book_Type_Code fa_book_controls.book_type_code%TYPE;
1092: WHERE line_location_id = x_po_line_location_id;
1093:
1094:
1095: l_total_quantity number;
1096: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1097: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
1098: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
1099: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
1100: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
1103: l_reason_unbuilt_flex varchar2(2000):='';
1104: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
1105: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1106: l_task_id po_distributions.task_id%TYPE;
1107: l_award_set_id po_distributions_all.award_id%TYPE;
1108: l_expenditure_type po_distributions.expenditure_type%TYPE;
1109: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;
1110: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;
1111: l_max_dist_amount number := 0;