APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on GL_JE_HEADERS

Line 27: vp_source GL_JE_HEADERS.JE_SOURCE%TYPE := NULL ;

23: vp_set_of_books_id number ;
24: vp_treasury_symbol Varchar2(35) ;
25: vp_start_date Date ;
26: vp_end_date Date ;
27: vp_source GL_JE_HEADERS.JE_SOURCE%TYPE := NULL ;
28: vp_category GL_JE_HEADERS.JE_CATEGORY%TYPE := NULL ;
29: vp_currency_code Varchar2(15) ;
30: p_jE_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE := NULL ;
31: -- ======================================================================

Line 28: vp_category GL_JE_HEADERS.JE_CATEGORY%TYPE := NULL ;

24: vp_treasury_symbol Varchar2(35) ;
25: vp_start_date Date ;
26: vp_end_date Date ;
27: vp_source GL_JE_HEADERS.JE_SOURCE%TYPE := NULL ;
28: vp_category GL_JE_HEADERS.JE_CATEGORY%TYPE := NULL ;
29: vp_currency_code Varchar2(15) ;
30: p_jE_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE := NULL ;
31: -- ======================================================================
32: -- FACTS Attributes

Line 30: p_jE_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE := NULL ;

26: vp_end_date Date ;
27: vp_source GL_JE_HEADERS.JE_SOURCE%TYPE := NULL ;
28: vp_category GL_JE_HEADERS.JE_CATEGORY%TYPE := NULL ;
29: vp_currency_code Varchar2(15) ;
30: p_jE_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE := NULL ;
31: -- ======================================================================
32: -- FACTS Attributes
33: -- ======================================================================
34:

Line 77: va_source GL_JE_HEADERS.JE_SOURCE%TYPE ;

73: -- Added New Variables for the Document Number and Date
74: --
75: va_document_number Varchar2(240) ;
76: va_document_Date Date ;
77: va_source GL_JE_HEADERS.JE_SOURCE%TYPE ;
78: va_category GL_JE_HEADERS.JE_CATEGORY%TYPE;
79: va_user_category GL_JE_CATEGORIES.USER_JE_CATEGORY_NAME%TYPE;
80: v_doc_created_by NUMBER(15) ;
81: v_doc_creation_date DATE ;

Line 78: va_category GL_JE_HEADERS.JE_CATEGORY%TYPE;

74: --
75: va_document_number Varchar2(240) ;
76: va_document_Date Date ;
77: va_source GL_JE_HEADERS.JE_SOURCE%TYPE ;
78: va_category GL_JE_HEADERS.JE_CATEGORY%TYPE;
79: va_user_category GL_JE_CATEGORIES.USER_JE_CATEGORY_NAME%TYPE;
80: v_doc_created_by NUMBER(15) ;
81: v_doc_creation_date DATE ;
82: v_ccid GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;

Line 552: vl_je_category GL_JE_HEADERS.JE_CATEGORY%TYPE;

548: vl_legis_ref4 Varchar2(240) ;
549: vl_legis_ref5 Varchar2(240) ;
550: vl_legis_ref9 Varchar2(240) ;
551: vl_je_date Date ;
552: vl_je_category GL_JE_HEADERS.JE_CATEGORY%TYPE;
553: vl_je_Source GL_JE_HEADERS.JE_SOURCE%TYPE;
554: --Start Bug 2464961--
555: -- vl_legis_amount Number ;
556: vl_legis_amount_dr NUMBER ;

Line 553: vl_je_Source GL_JE_HEADERS.JE_SOURCE%TYPE;

549: vl_legis_ref5 Varchar2(240) ;
550: vl_legis_ref9 Varchar2(240) ;
551: vl_je_date Date ;
552: vl_je_category GL_JE_HEADERS.JE_CATEGORY%TYPE;
553: vl_je_Source GL_JE_HEADERS.JE_SOURCE%TYPE;
554: --Start Bug 2464961--
555: -- vl_legis_amount Number ;
556: vl_legis_amount_dr NUMBER ;
557: vl_legis_amount_cr NUMBER ;

Line 975: GL_JE_SOURCES instead of table GL_JE_HEADERS*/

971: */
972:
973: /*Bug #2469438
974: Modified the selct statement to read column user_je_source_name from table
975: GL_JE_SOURCES instead of table GL_JE_HEADERS*/
976: /*Bug #2469438 Undo the above change*/
977:
978: /* Bug 2464961
979: Modified the select statement to select gjl.entered_dr , gjl.entered_cr

Line 1023: gl_je_headers glh,

1019: ',glcc.code_combination_id,glh.created_by,glh.creation_date'||
1020: ',GLCC.' ||v_fyr_segment_name ||
1021: v_cohort_select||
1022: ' From gl_je_lines gjl,
1023: gl_je_headers glh,
1024: gl_je_batches glb,
1025: gl_je_categories glc,
1026: gl_code_combinations glcc,
1027: fv_fund_parameters ffp

Line 2372: FROM gl_je_headers

2368:
2369: --Start Bug 2464961--
2370: Cursor manual_csr is
2371: SELECT default_effective_date
2372: FROM gl_je_headers
2373: WHERE je_header_id = p_je_header_id;
2374:
2375: --End Bug 2464961--
2376: