APPS.JL_ZZ_FA_DRILL_DOWN_PKG dependencies on FA_BOOK_CONTROLS

Line 36: Though, gl_je_source value is available in fa_book_controls

32: /* Bug 5136047:
33: In R12 due to SLA uptake, core FA no longer allows "GL journal entry source"
34: to be entered using Book Controls window.
35: "GL journal entry source" is set at the application level in SLA.
36: Though, gl_je_source value is available in fa_book_controls
37: for books upgraded from R11i, the source of truth is always as follows.
38: The "GL journal entry source" will be derived from JE_SOURCE_NAME from
39: XLA_SUBLEDGERS for application_id = 140.
40: Hence, there is no need to look at fa_book_controls for books upgraded

Line 40: Hence, there is no need to look at fa_book_controls for books upgraded

36: Though, gl_je_source value is available in fa_book_controls
37: for books upgraded from R11i, the source of truth is always as follows.
38: The "GL journal entry source" will be derived from JE_SOURCE_NAME from
39: XLA_SUBLEDGERS for application_id = 140.
40: Hence, there is no need to look at fa_book_controls for books upgraded
41: from R1i.
42: */
43:
44: CURSOR fab_c ( c_jeh_id NUMBER,

Line 50: FROM fa_book_controls bc,

46: c_je_category VARCHAR2) IS
47: SELECT 140
48: FROM DUAL
49: WHERE EXISTS ( SELECT 1
50: FROM fa_book_controls bc,
51: gl_je_headers jeh,
52: xla_subledgers xs
53: WHERE jeh.je_header_id = c_jeh_id
54: AND bc.set_of_books_id = jeh.ledger_id