APPS.FV_FACTS_TRANSACTIONS dependencies on GL_PERIOD_STATUSES

Line 83: v_period_num gl_period_statuses.period_num%TYPE ;

79:
80: -- ========================================================================
81: -- Other GLOBAL Variables
82: -- ========================================================================
83: v_period_num gl_period_statuses.period_num%TYPE ;
84: --v_debug varchar2(1) := NVL(FND_PROFILE.VALUE('FV_DEBUG_FLAG'),'N');
85: v_year_gtn2001 BOOLEAN ;
86: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE ;
87: v_chart_of_accounts_id gl_code_combinations.chart_of_accounts_id%TYPE ;

Line 97: v_period_name gl_period_statuses.period_name%TYPE ;

93:
94: -- CGAC: Report financing_account from fv_treasury_symbols
95: v_financing_acct fv_treasury_symbols.financing_account%TYPE ;
96: v_cohort_seg_name VARCHAR2(20) ;
97: v_period_name gl_period_statuses.period_name%TYPE ;
98: v_period_start_dt DATE ;
99: v_period_end_dt DATE ;
100: v_begin_period_name gl_period_statuses.period_name%TYPE ;
101: v_begin_period_start_dt DATE ;

Line 100: v_begin_period_name gl_period_statuses.period_name%TYPE ;

96: v_cohort_seg_name VARCHAR2(20) ;
97: v_period_name gl_period_statuses.period_name%TYPE ;
98: v_period_start_dt DATE ;
99: v_period_end_dt DATE ;
100: v_begin_period_name gl_period_statuses.period_name%TYPE ;
101: v_begin_period_start_dt DATE ;
102: v_begin_period_end_dt DATE ;
103: v_begin_period_num gl_period_statuses.period_num%TYPE ;
104: v_cohort_select VARCHAR2(20) ;

Line 103: v_begin_period_num gl_period_statuses.period_num%TYPE ;

99: v_period_end_dt DATE ;
100: v_begin_period_name gl_period_statuses.period_name%TYPE ;
101: v_begin_period_start_dt DATE ;
102: v_begin_period_end_dt DATE ;
103: v_begin_period_num gl_period_statuses.period_num%TYPE ;
104: v_cohort_select VARCHAR2(20) ;
105: v_fiscal_yr VARCHAR2(25);
106: v_dummy_cohort VARCHAR2(25);
107: v_acct_attr_flag VARCHAR2(1) ;

Line 1007: FROM gl_period_statuses

1003: vc_rpt_fiscal_yr := LPAD(to_char(vp_report_fiscal_yr), 4) ;
1004:
1005: SELECT to_char(count(*) , '09')
1006: INTO vl_fiscal_month_count
1007: FROM gl_period_statuses
1008: WHERE ledger_id = vp_set_of_books_id
1009: AND application_id = 101
1010: AND period_year = vp_report_fiscal_yr
1011: -- AND adjustment_period_flag = 'N'

Line 1058: FROM gl_period_statuses

1054: INTO v_period_name,
1055: v_period_start_dt,
1056: v_period_end_dt,
1057: vp_report_qtr
1058: FROM gl_period_statuses
1059: WHERE ledger_id = vp_set_of_books_id
1060: AND application_id = 101
1061: AND period_year = vp_report_fiscal_yr
1062: AND period_num = v_period_num ;

Line 1101: FROM gl_period_statuses

1097: INTO v_begin_period_name,
1098: v_begin_period_start_dt,
1099: v_begin_period_end_dt,
1100: v_begin_period_num
1101: FROM gl_period_statuses
1102: WHERE period_num =
1103: (SELECT MIN(period_num)
1104: FROM gl_period_statuses
1105: WHERE period_year = vp_report_fiscal_yr

Line 1104: FROM gl_period_statuses

1100: v_begin_period_num
1101: FROM gl_period_statuses
1102: WHERE period_num =
1103: (SELECT MIN(period_num)
1104: FROM gl_period_statuses
1105: WHERE period_year = vp_report_fiscal_yr
1106: AND ledger_id = vp_set_of_books_id
1107: AND application_id = 101
1108: AND adjustment_period_flag = 'N')

Line 1936: FROM gl_period_statuses

1932:
1933: vl_legis_select :=
1934: vl_legis_select || ' AND gjl.period_name in ' ||
1935: ' ( SELECT period_name
1936: FROM gl_period_statuses
1937: WHERE application_id = 101
1938: AND ledger_id = :set_of_books_id
1939: AND period_num BETWEEN :begin_period_num AND :period_num
1940: AND period_year = :report_fiscal_yr) ' ;

Line 1982: FROM gl_period_statuses

1978: --AND xl.code_combination_id = glcc.code_combination_id
1979: vl_legis_select :=
1980: vl_legis_select || ' AND gjl.period_name in ' ||
1981: ' ( SELECT period_name
1982: FROM gl_period_statuses
1983: WHERE application_id = 101
1984: AND ledger_id = :set_of_books_id
1985: AND period_num BETWEEN :begin_period_num AND :period_num
1986: AND period_year = :report_fiscal_yr) ' ;