APPS.JAI_AP_MATCH_TAX_PKG dependencies on GL_SETS_OF_BOOKS

Line 662: FROM gl_sets_of_books

658:
659:
660: CURSOR c_functional_currency(p_sob NUMBER) IS -- cursor added for bug#3354932
661: SELECT currency_code
662: FROM gl_sets_of_books
663: WHERE set_of_books_id = p_sob;
664:
665: CURSOR checking_for_packing_slip(ven_id NUMBER, ven_site_id NUMBER, v_org_id NUMBER) IS
666: SELECT pay_on_code, pay_on_receipt_summary_code

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

1210: v_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
1211: v_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;--bug#367196
1212: v_update_payment_schedule boolean; -- bug#3218978
1213: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type; -- bug#3332988
1214: v_functional_currency gl_sets_of_books.currency_code%type; -- bug#3354932
1215: v_batch_id NUMBER;
1216: c_tax_rec c_tax%ROWTYPE;
1217: v_source VARCHAR2(25);
1218: apccid ap_invoices_all.ACCTS_PAY_CODE_COMBINATION_ID%TYPE;

Line 1221: caid gl_sets_of_books.chart_of_accounts_id%TYPE;

1217: v_source VARCHAR2(25);
1218: apccid ap_invoices_all.ACCTS_PAY_CODE_COMBINATION_ID%TYPE;
1219: shpmnt_ln_id rcv_shipment_lines.shipment_line_id%TYPE;
1220: cur_items_rec cur_items%ROWTYPE;
1221: caid gl_sets_of_books.chart_of_accounts_id%TYPE;
1222: from_po_distributions_rec from_po_distributions%ROWTYPE;
1223: for_dist_insertion_rec for_dist_insertion%ROWTYPE;
1224: cum_tax_amt NUMBER := -1;--modified by kunkumar for 5593895
1225: v_tax_amount NUMBER;

Line 2480: FROM gl_sets_of_books

2476: IF v_source <> 'SUPPLEMENT' THEN
2477:
2478: BEGIN --06-Mar-2002
2479: SELECT chart_of_accounts_id INTO caid
2480: FROM gl_sets_of_books
2481: WHERE set_of_books_id = cur_items_rec.set_of_books_id;
2482: EXCEPTION
2483: WHEN OTHERS THEN
2484: ERRBUF := SQLERRM;

Line 7235: FROM gl_sets_of_books

7231: WHERE invoice_id = v_invoice_id;
7232:
7233: CURSOR c_functional_currency(p_sob NUMBER) IS -- cursor added for bug#3354932
7234: SELECT currency_code
7235: FROM gl_sets_of_books
7236: WHERE set_of_books_id = p_sob;
7237:
7238: CURSOR checking_for_packing_slip(ven_id NUMBER, ven_site_id NUMBER, v_org_id NUMBER) IS
7239: SELECT pay_on_code, pay_on_receipt_summary_code

Line 7507: caid gl_sets_of_books.chart_of_accounts_id%TYPE;

7503: c_tax_rec c_tax%ROWTYPE;
7504: v_source VARCHAR2(25);
7505: shpmnt_ln_id rcv_shipment_lines.shipment_line_id%TYPE;
7506: cur_items_rec cur_items%ROWTYPE;
7507: caid gl_sets_of_books.chart_of_accounts_id%TYPE;
7508: for_dist_insertion_rec for_dist_insertion%ROWTYPE;
7509: cum_tax_amt NUMBER := 0;
7510: v_distribution_no NUMBER;
7511: v_tax_amount NUMBER;

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

7514: for_org_id_rec for_org_id%ROWTYPE;
7515: -- for_acct_id_rec for_acct_id%ROWTYPE;
7516: --commented the above by Sanjikum For Bug#4474501, as this variable is not being used anywhere
7517: v_cor_factor NUMBER;
7518: v_functional_currency gl_sets_of_books.currency_code%type; -- added for bug#3354932
7519: count_dist_no_rec NUMBER;
7520: v_attribute12 VARCHAR2(150);
7521: v_ATTRIBUTE2 VARCHAR2(150);
7522: v_sup_po_header_id NUMBER;

Line 8257: FROM gl_sets_of_books

8253: IF v_source <> 'SUPPLEMENT' THEN
8254:
8255: BEGIN --06-Mar-2002
8256: SELECT chart_of_accounts_id INTO caid
8257: FROM gl_sets_of_books
8258: WHERE set_of_books_id = cur_items_rec.set_of_books_id;
8259: EXCEPTION
8260: WHEN OTHERS THEN
8261: NULL;