DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_SETTLEMENT_PKG dependencies on AP_INVOICE_LINES_INTERFACE

Line 1010: FROM ap_invoice_lines_interface

1006: WHERE vendor_id = pn_vendor_id;
1007:
1008: CURSOR counter_cur(pn_invoice_id ap_invoices_interface.invoice_id%TYPE) IS
1009: SELECT NVL(MAX(line_number),0)
1010: FROM ap_invoice_lines_interface
1011: -- bug 4929081. Added by Lakshmi Gopalsami
1012: WHERE invoice_id = pn_invoice_id;
1013:
1014: CURSOR cur_invoice_no IS

Line 1092: ln_dist_code_combination_id ap_invoice_lines_interface.dist_code_combination_id%TYPE;

1088: lv_currency_code gl_sets_of_books.currency_code%TYPE;
1089: for_terms_id_rec for_terms_id%ROWTYPE;
1090: counter_tds_dm_v NUMBER;
1091: ln_tmp NUMBER;
1092: ln_dist_code_combination_id ap_invoice_lines_interface.dist_code_combination_id%TYPE;
1093: lv_tax_type jai_rgm_stl_balances.tax_type%TYPE;
1094: lv_tax_type1 jai_rgm_stl_balances.tax_type%TYPE;
1095: lv_tax_type2 jai_rgm_stl_balances.tax_type%TYPE;
1096: ln_amount jai_rgm_stl_balances.debit_balance%TYPE;