DBA Data[Home] [Help]

APPS.JAI_AP_MATCH_TAX_PROC_PKG dependencies on GL_CODE_COMBINATIONS

Line 1576: FROM gl_code_combinations

1572: AND pda.po_distribution_id = pr_ap_inv_line_item.po_distribution_id;
1573:
1574: CURSOR get_account_type IS
1575: SELECT account_type
1576: FROM gl_code_combinations
1577: WHERE code_combination_id = pr_ap_inv_dist_item.dist_code_combination_id;
1578:
1579: CURSOR Fetch_Shipment_Line_Id_Cur( invorg IN NUMBER, receiptnum IN VARCHAR2 ) IS
1580: SELECT Shipment_Line_Id, Shipment_Header_Id

Line 1647: lv_account_type gl_code_combinations.account_type%TYPE;

1643: v_tax_variance_inv_cur NUMBER;
1644: v_tax_variance_fun_cur NUMBER;
1645: v_price_var_accnt NUMBER;
1646: for_org_id_rec for_org_id%ROWTYPE;
1647: lv_account_type gl_code_combinations.account_type%TYPE;
1648: ln_project_id ap_invoice_lines.project_id%TYPE;
1649: ln_task_id ap_invoice_lines.task_id%TYPE;
1650: lv_exp_type ap_invoice_lines.expenditure_type%TYPE;
1651: ld_exp_item_date ap_invoice_lines.expenditure_item_date%TYPE;