DBA Data[Home] [Help]

APPS.GL_JOURNAL_IMPORT_TAX_PKG dependencies on GL_JE_LINES

Line 97: FROM gl_je_lines

93: IS
94: SELECT period_name,effective_date,status,
95: tax_code,amount_includes_tax_flag,tax_code_id,
96: attribute9,attribute10
97: FROM gl_je_lines
98: WHERE je_header_id = header_id_in
99: FOR UPDATE;
100: --
101: BEGIN

Line 335: -- then update gl_je_lines details

331: IF l_je_line_found = 1
332: THEN
333: --
334: -- if tax details are present in current line,
335: -- then update gl_je_lines details
336: --
337:
338: UPDATE gl_je_lines
339: SET tax_code_id = l_je_line_tax_code_id,

Line 338: UPDATE gl_je_lines

334: -- if tax details are present in current line,
335: -- then update gl_je_lines details
336: --
337:
338: UPDATE gl_je_lines
339: SET tax_code_id = l_je_line_tax_code_id,
340: amount_includes_tax_flag = l_je_line_tax_flag,
341: tax_type_code = l_je_line_tax_type_code,
342: tax_rounding_rule_code = 'N',

Line 440: FROM gl_je_lines

436: IS
437: SELECT je_line_num,period_name,effective_date,status,
438: tax_code,amount_includes_tax_flag,tax_code_id,
439: attribute9,attribute10
440: FROM gl_je_lines
441: WHERE je_header_id = header_id_in
442: FOR UPDATE;
443: --
444: BEGIN

Line 678: -- then update gl_je_lines details

674: IF l_je_line_found = 1
675: THEN
676: --
677: -- if tax details are present in current line,
678: -- then update gl_je_lines details
679: --
680: UPDATE gl_je_lines
681: SET tax_code_id = l_je_line_tax_code_id,
682: amount_includes_tax_flag = l_je_line_tax_flag,

Line 680: UPDATE gl_je_lines

676: --
677: -- if tax details are present in current line,
678: -- then update gl_je_lines details
679: --
680: UPDATE gl_je_lines
681: SET tax_code_id = l_je_line_tax_code_id,
682: amount_includes_tax_flag = l_je_line_tax_flag,
683: tax_type_code = l_je_line_tax_type_code,
684: tax_rounding_rule_code = 'N',