APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on GL_CODE_COMBINATIONS

Line 82: v_ccid GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%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;
84:
85: -- ======================================================================
86: -- FACTS File Constants

Line 692: ' FROM GL_CODE_COMBINATIONS GLCC,

688:
689: -- Get the balances for the Account Number and Fund Value
690: vl_main_select := 'SELECT DISTINCT GLCC.'||v_acc_seg_name||
691: ', GLCC.'||v_bal_seg_name||v_cohort_select||
692: ' FROM GL_CODE_COMBINATIONS GLCC,
693: FV_FUND_PARAMETERS FFP,
694: FV_TREASURY_SYMBOLS FTS
695: WHERE FTS.TREASURY_SYMBOL = ' ||''''||vp_treasury_symbol||'''' ||
696: --pkpatel :changed to fix Bug 1575992

Line 705: ' AND EXISTS (SELECT 1 FROM gl_code_combinations glcc2

701:
702:
703: IF v_pagebreak1 IS NOT NULL THEN
704: vl_main_select := vl_main_select ||
705: ' AND EXISTS (SELECT 1 FROM gl_code_combinations glcc2
706: WHERE glcc.code_combination_id = glcc2.code_combination_id '
707: || ' AND glcc2.' || vl_pagebreak1_seg ||
708: ' BETWEEN '|| ''''|| v_pagebreak1_low || '''' || ' AND '
709: || ''''|| v_pagebreak1_high || '''' ;

Line 819: GL_CODE_COMBINATIONS GLCC

815:
816: vl_amount_select :=
817: 'SELECT NVL(SUM(nvl(BEGIN_BALANCE_DR,0) - nvl(BEGIN_BALANCE_CR,0)),0)
818: FROM GL_BALANCES GLB,
819: GL_CODE_COMBINATIONS GLCC
820: WHERE GLB.code_combination_id = GLCC.code_combination_id
821: AND GLB.TEMPLATE_ID IS NULL
822: AND GLB.actual_flag = '||''''||vl_actual_flag||''''
823: || ' AND GLB.SET_OF_BOOKS_ID = ' || vp_set_of_books_id

Line 1026: gl_code_combinations glcc,

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
1030: Where Adjustment_Period_Flag = '||''''||'Y'||''''||

Line 1048: ' AND EXISTS (SELECT 1 FROM gl_code_combinations glcc2

1044: ' AND glh.currency_code = ' || '''' || vp_currency_code || '''' ;
1045:
1046: IF v_pagebreak1 IS NOT NULL THEN
1047: vl_legis_select := vl_legis_select ||
1048: ' AND EXISTS (SELECT 1 FROM gl_code_combinations glcc2
1049: WHERE glcc.code_combination_id = glcc2.code_combination_id '
1050: || ' AND glcc2.' || vl_pagebreak1_seg ||
1051: ' BETWEEN '|| ''''|| v_pagebreak1_low || '''' || ' AND '
1052: || ''''|| v_pagebreak1_high || '''';