APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on GL_JE_CATEGORIES

Line 79: va_user_category GL_JE_CATEGORIES.USER_JE_CATEGORY_NAME%TYPE;

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;
83: v_seg_fiscal_yr fv_pya_fiscalyear_map.fyr_segment_value%type;

Line 1025: gl_je_categories glc,

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
1028: Where gjl.code_combination_id = glcc.code_combination_id
1029: and gjl.Period_Name NOT IN (Select Period_Name From GL_Period_Statuses

Line 1249: From GL_JE_Categories

1245: IF upper(va_source) = 'MANUAL' THEN
1246: Begin
1247: Select User_Je_Category_Name
1248: Into va_user_category
1249: From GL_JE_Categories
1250: Where Je_Category_Name = va_category;
1251: va_category := va_user_category;
1252: Exception
1253: When Others then