APPS.JAI_AP_TDS_TAX_DEFAULTATION dependencies on GL_SETS_OF_BOOKS

Line 95: cursor c_gl_sets_of_books(cp_set_of_books_id number) is

91: p_codepath in out nocopy varchar2
92: )
93: is
94:
95: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
96: select currency_code
97: from gl_sets_of_books
98: where set_of_books_id = cp_set_of_books_id;
99:

Line 97: from gl_sets_of_books

93: is
94:
95: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
96: select currency_code
97: from gl_sets_of_books
98: where set_of_books_id = cp_set_of_books_id;
99:
100: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
101:

Line 100: r_gl_sets_of_books c_gl_sets_of_books%rowtype;

96: select currency_code
97: from gl_sets_of_books
98: where set_of_books_id = cp_set_of_books_id;
99:
100: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
101:
102: lv_default_tds_section_code jai_ap_tds_inv_taxes.default_section_code%type;
103: ln_default_tds_tax_id jai_ap_tds_inv_taxes.default_tax_id%type;
104: lv_default_from jai_ap_tds_inv_taxes.default_from%type;

Line 131: open c_gl_sets_of_books(p_set_of_books_id);

127: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
128: goto exit_from_procedure;
129: end if;
130:
131: open c_gl_sets_of_books(p_set_of_books_id);
132: fetch c_gl_sets_of_books into r_gl_sets_of_books;
133: close c_gl_sets_of_books;
134:
135: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */

Line 132: fetch c_gl_sets_of_books into r_gl_sets_of_books;

128: goto exit_from_procedure;
129: end if;
130:
131: open c_gl_sets_of_books(p_set_of_books_id);
132: fetch c_gl_sets_of_books into r_gl_sets_of_books;
133: close c_gl_sets_of_books;
134:
135: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
136: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then

Line 133: close c_gl_sets_of_books;

129: end if;
130:
131: open c_gl_sets_of_books(p_set_of_books_id);
132: fetch c_gl_sets_of_books into r_gl_sets_of_books;
133: close c_gl_sets_of_books;
134:
135: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
136: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
137: /* Foreign currency invoice */

Line 136: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then

132: fetch c_gl_sets_of_books into r_gl_sets_of_books;
133: close c_gl_sets_of_books;
134:
135: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
136: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
137: /* Foreign currency invoice */
138: p_codepath := jai_general_pkg.plot_codepath(3.1, p_codepath); /* 3.1 */
139: ln_exchange_rate := p_exchange_rate;
140: end if;