APPS.JAI_AP_MATCH_TAX_PKG dependencies on GL_SETS_OF_BOOKS

Line 502: FROM gl_sets_of_books

498: WHERE invoice_id = v_invoice_id;
499:
500: CURSOR c_functional_currency(p_sob NUMBER) IS -- cursor added for bug#3354932
501: SELECT currency_code
502: FROM gl_sets_of_books
503: WHERE set_of_books_id = p_sob;
504:
505: CURSOR checking_for_packing_slip(ven_id NUMBER, ven_site_id NUMBER, v_org_id NUMBER) IS
506: SELECT pay_on_code, pay_on_receipt_summary_code

Line 918: v_functional_currency gl_sets_of_books.currency_code%type; -- bug#3354932

914: v_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
915: v_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;--bug#367196
916: v_update_payment_schedule boolean; -- bug#3218978
917: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type; -- bug#3332988
918: v_functional_currency gl_sets_of_books.currency_code%type; -- bug#3354932
919: v_batch_id NUMBER;
920: c_tax_rec c_tax%ROWTYPE;
921: v_source VARCHAR2(25);
922: apccid ap_invoices_all.ACCTS_PAY_CODE_COMBINATION_ID%TYPE;

Line 925: caid gl_sets_of_books.chart_of_accounts_id%TYPE;

921: v_source VARCHAR2(25);
922: apccid ap_invoices_all.ACCTS_PAY_CODE_COMBINATION_ID%TYPE;
923: shpmnt_ln_id rcv_shipment_lines.shipment_line_id%TYPE;
924: cur_items_rec cur_items%ROWTYPE;
925: caid gl_sets_of_books.chart_of_accounts_id%TYPE;
926: from_po_distributions_rec from_po_distributions%ROWTYPE;
927: for_dist_insertion_rec for_dist_insertion%ROWTYPE;
928: cum_tax_amt NUMBER := -1;--modified by kunkumar for 5593895
929: v_tax_amount NUMBER;

Line 1860: FROM gl_sets_of_books

1856: IF v_source <> 'SUPPLEMENT' THEN
1857:
1858: BEGIN --06-Mar-2002
1859: SELECT chart_of_accounts_id INTO caid
1860: FROM gl_sets_of_books
1861: WHERE set_of_books_id = cur_items_rec.set_of_books_id;
1862: EXCEPTION
1863: WHEN OTHERS THEN
1864: ERRBUF := SQLERRM;

Line 5686: FROM gl_sets_of_books

5682: WHERE invoice_id = v_invoice_id;
5683:
5684: CURSOR c_functional_currency(p_sob NUMBER) IS -- cursor added for bug#3354932
5685: SELECT currency_code
5686: FROM gl_sets_of_books
5687: WHERE set_of_books_id = p_sob;
5688:
5689: CURSOR checking_for_packing_slip(ven_id NUMBER, ven_site_id NUMBER, v_org_id NUMBER) IS
5690: SELECT pay_on_code, pay_on_receipt_summary_code

Line 5956: caid gl_sets_of_books.chart_of_accounts_id%TYPE;

5952: c_tax_rec c_tax%ROWTYPE;
5953: v_source VARCHAR2(25);
5954: shpmnt_ln_id rcv_shipment_lines.shipment_line_id%TYPE;
5955: cur_items_rec cur_items%ROWTYPE;
5956: caid gl_sets_of_books.chart_of_accounts_id%TYPE;
5957: for_dist_insertion_rec for_dist_insertion%ROWTYPE;
5958: cum_tax_amt NUMBER := 0;
5959: v_distribution_no NUMBER;
5960: v_tax_amount NUMBER;

Line 5967: v_functional_currency gl_sets_of_books.currency_code%type; -- added for bug#3354932

5963: for_org_id_rec for_org_id%ROWTYPE;
5964: -- for_acct_id_rec for_acct_id%ROWTYPE;
5965: --commented the above by Sanjikum For Bug#4474501, as this variable is not being used anywhere
5966: v_cor_factor NUMBER;
5967: v_functional_currency gl_sets_of_books.currency_code%type; -- added for bug#3354932
5968: count_dist_no_rec NUMBER;
5969: v_attribute12 VARCHAR2(150);
5970: v_ATTRIBUTE2 VARCHAR2(150);
5971: v_sup_po_header_id NUMBER;

Line 6703: FROM gl_sets_of_books

6699: IF v_source <> 'SUPPLEMENT' THEN
6700:
6701: BEGIN --06-Mar-2002
6702: SELECT chart_of_accounts_id INTO caid
6703: FROM gl_sets_of_books
6704: WHERE set_of_books_id = cur_items_rec.set_of_books_id;
6705: EXCEPTION
6706: WHEN OTHERS THEN
6707: NULL;