APPS.JE_IT_TAX_EX_UPGRADE dependencies on JE_IT_EXEMPT_LETTERS

Line 22: -- Update Legal Entity for je_it_year_ex_limit and je_it_exempt_letters tables.

18: retcode := 0;
19: errbuf := NULL;
20:
21:
22: -- Update Legal Entity for je_it_year_ex_limit and je_it_exempt_letters tables.
23: IF (p_legal_entity_id IS NOT NULL) THEN
24:
25: UPDATE je_it_year_ex_limit
26: SET legal_entity_id = p_legal_entity_id

Line 35: UPDATE je_it_exempt_letters

31: legal entity id: '||p_legal_entity_id||
32: ' for set of books id: '||p_set_of_books_id;
33: fnd_file.put_line(fnd_file.log,l_message);
34:
35: UPDATE je_it_exempt_letters
36: SET legal_entity_id = p_legal_entity_id
37: WHERE set_of_books_id = p_set_of_books_id
38: AND legal_entity_id IS NULL;
39:

Line 40: l_message := 'Updated '||SQL%ROWCOUNT||' rows in table je_it_exempt_letters with

36: SET legal_entity_id = p_legal_entity_id
37: WHERE set_of_books_id = p_set_of_books_id
38: AND legal_entity_id IS NULL;
39:
40: l_message := 'Updated '||SQL%ROWCOUNT||' rows in table je_it_exempt_letters with
41: legal entity id: '||p_legal_entity_id||
42: ' for set of books id: '||p_set_of_books_id;
43: fnd_file.put_line(fnd_file.log,l_message);
44: