APPS.JAI_AP_ST_REVERSE_PROCESS dependencies on GL_SETS_OF_BOOKS

Line 3105: FROM gl_sets_of_books

3101: and po_distribution_id = po_dist_id;
3102:
3103: CURSOR c_functional_currency(p_sob NUMBER) IS -- cursor added for bug#3354932
3104: SELECT currency_code
3105: FROM gl_sets_of_books
3106: WHERE set_of_books_id = p_sob;
3107:
3108: CURSOR checking_for_packing_slip(ven_id NUMBER, ven_site_id NUMBER, v_org_id NUMBER) IS
3109: SELECT pay_on_code, pay_on_receipt_summary_code

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

3594: v_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;--bug#367196
3595: v_dist_ccid_liability ap_invoice_distributions_all.dist_code_combination_id%type;
3596: v_update_payment_schedule boolean; -- bug#3218978
3597: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type; -- bug#3332988
3598: v_functional_currency gl_sets_of_books.currency_code%type; -- bug#3354932
3599: v_batch_id NUMBER;
3600: c_tax_rec c_tax%ROWTYPE;
3601: v_source VARCHAR2(25);
3602: apccid ap_invoices_all.ACCTS_PAY_CODE_COMBINATION_ID%TYPE;

Line 5384: FROM gl_sets_of_books

5380: WHERE invoice_id = v_invoice_id;
5381:
5382: CURSOR c_functional_currency(p_sob NUMBER) IS -- cursor added for bug#3354932
5383: SELECT currency_code
5384: FROM gl_sets_of_books
5385: WHERE set_of_books_id = p_sob;
5386:
5387: CURSOR checking_for_packing_slip(ven_id NUMBER, ven_site_id NUMBER, v_org_id NUMBER) IS
5388: SELECT pay_on_code, pay_on_receipt_summary_code

Line 5656: caid gl_sets_of_books.chart_of_accounts_id%TYPE;

5652: c_tax_rec c_tax%ROWTYPE;
5653: v_source VARCHAR2(25);
5654: shpmnt_ln_id rcv_shipment_lines.shipment_line_id%TYPE;
5655: cur_items_rec cur_items%ROWTYPE;
5656: caid gl_sets_of_books.chart_of_accounts_id%TYPE;
5657: for_dist_insertion_rec for_dist_insertion%ROWTYPE;
5658: cum_tax_amt NUMBER := 0;
5659: v_distribution_no NUMBER;
5660: v_tax_amount NUMBER;

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

5664: for_org_id_rec for_org_id%ROWTYPE;
5665: -- for_acct_id_rec for_acct_id%ROWTYPE;
5666: --commented the above by Sanjikum For Bug#4474501, as this variable is not being used anywhere
5667: v_cor_factor NUMBER;
5668: v_functional_currency gl_sets_of_books.currency_code%type; -- added for bug#3354932
5669: count_dist_no_rec NUMBER;
5670: v_attribute12 VARCHAR2(150);
5671: v_ATTRIBUTE2 VARCHAR2(150);
5672: v_sup_po_header_id NUMBER;

Line 5938: FROM gl_sets_of_books

5934: IF v_source <> 'SUPPLEMENT' THEN
5935:
5936: BEGIN
5937: SELECT chart_of_accounts_id INTO caid
5938: FROM gl_sets_of_books
5939: WHERE set_of_books_id = cur_items_rec.set_of_books_id;
5940: EXCEPTION
5941: WHEN OTHERS THEN
5942: NULL;