APPS.JE_GR_STATUTORY dependencies on GL_SETS_OF_BOOKS

Line 21: gl_sets_of_books sob,

17: -- sob.global_attribute_category
18: -- nvl(sob.global_attribute2, 'N'),
19: -- nvl(sob.global_attribute3, 'N')
20: FROM
21: gl_sets_of_books sob,
22: fnd_doc_sequence_categories doc,
23: fnd_application a,
24: gl_je_headers jh,
25: gl_je_batches jb

Line 45: v_pkg_ledger_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE; --??

41: v_pkg_trx_date DATE;
42: v_pkg_last_batch_id GL_JE_BATCHES.je_batch_id%TYPE := 0;
43: v_pkg_category_code FND_DOC_SEQUENCE_CATEGORIES.code%TYPE;
44: v_pkg_cat_application_id FND_DOC_SEQUENCE_CATEGORIES.application_id%TYPE;
45: v_pkg_ledger_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE; --??
46: --v_pkg_global_attribute GL_SETS_OF_BOOKS.global_attribute1%TYPE;
47: v_pkg_sequence_ax_journals VARCHAR2(150);
48: v_pkg_append_sequence VARCHAR2(150);
49:

Line 46: --v_pkg_global_attribute GL_SETS_OF_BOOKS.global_attribute1%TYPE;

42: v_pkg_last_batch_id GL_JE_BATCHES.je_batch_id%TYPE := 0;
43: v_pkg_category_code FND_DOC_SEQUENCE_CATEGORIES.code%TYPE;
44: v_pkg_cat_application_id FND_DOC_SEQUENCE_CATEGORIES.application_id%TYPE;
45: v_pkg_ledger_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE; --??
46: --v_pkg_global_attribute GL_SETS_OF_BOOKS.global_attribute1%TYPE;
47: v_pkg_sequence_ax_journals VARCHAR2(150);
48: v_pkg_append_sequence VARCHAR2(150);
49:
50: /*------------------------------------------------------------------+

Line 79: v_pkg_ledger_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

75:
76: idx BINARY_INTEGER;
77: v_pkg_category_code FND_DOC_SEQUENCE_CATEGORIES.code%TYPE;
78: v_pkg_cat_application_id FND_DOC_SEQUENCE_CATEGORIES.application_id%TYPE;
79: v_pkg_ledger_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
80: v_days JE_GR_CUTOFF_RULES.days%TYPE;
81: v_violation_response JE_GR_CUTOFF_RULES.violation_response%TYPE;
82: v_enabled_flag JE_GR_CUTOFF_RULES.enabled_flag%TYPE;
83:

Line 366: FROM gl_sets_of_books

362: /*SELECT global_attribute_category
363: --to_number(nvl(global_attribute1, 15))**
364: INTO v_global
365: v_default_cutoff_days
366: FROM gl_sets_of_books
367: WHERE set_of_books_id = p_ledger_id;--??
368: */
369: IF (v_global = 'GR') THEN
370: