DBA Data[Home] [Help]

APPS.GL_JOURNAL_IMPORT_TAX_PKG dependencies on GL_JE_BATCHES

Line 15: FROM gl_je_batches

11: --
12: BEGIN
13: SELECT je_batch_id
14: INTO l_batch_id
15: FROM gl_je_batches
16: WHERE name = p_batch_name AND
17: ROWNUM = 1;
18: --
19: EXCEPTION

Line 110: FROM GL_JE_BATCHES

106: approval_status_code, status, name
107: INTO l_org_id,
108: l_budgetary_control_status, l_actual_flag,
109: l_approval_status_code, l_status, l_name
110: FROM GL_JE_BATCHES
111: WHERE je_batch_id = p_batch_id;
112:
113: --
114: EXCEPTION

Line 382: UPDATE gl_je_batches

378: -- do not forget to update org_id at batch level
379: --
380: IF l_batch_tax_required = 1
381: THEN
382: UPDATE gl_je_batches
383: SET org_id = l_org_id
384: WHERE je_batch_id = p_batch_id;
385: END IF;
386: --

Line 453: FROM GL_JE_BATCHES

449: approval_status_code, status, name
450: INTO l_org_id,
451: l_budgetary_control_status, l_actual_flag,
452: l_approval_status_code, l_status, l_name
453: FROM GL_JE_BATCHES
454: WHERE je_batch_id = p_batch_id;
455: --
456: EXCEPTION
457: WHEN NO_DATA_FOUND

Line 726: UPDATE gl_je_batches

722: -- do not forget to update org_id at batch level
723: --
724: IF l_batch_tax_required = 1
725: THEN
726: UPDATE gl_je_batches
727: SET org_id = l_org_id
728: WHERE je_batch_id = p_batch_id;
729: END IF;
730: --