APPS.FV_FACTS_TRANSACTIONS dependencies on GL_PERIOD_STATUSES

Line 79: v_period_num gl_period_statuses.period_num%TYPE ;

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

Line 91: v_period_name gl_period_statuses.period_name%TYPE ;

87: v_fyr_segment_name VARCHAR2(20);
88: v_time_frame fv_treasury_symbols.time_frame%TYPE ;
89: v_financing_acct fv_facts_federal_accounts.financing_account%TYPE ;
90: v_cohort_seg_name VARCHAR2(20) ;
91: v_period_name gl_period_statuses.period_name%TYPE ;
92: v_period_start_dt DATE ;
93: v_period_end_dt DATE ;
94: v_begin_period_name gl_period_statuses.period_name%TYPE ;
95: v_begin_period_start_dt DATE ;

Line 94: v_begin_period_name gl_period_statuses.period_name%TYPE ;

90: v_cohort_seg_name VARCHAR2(20) ;
91: v_period_name gl_period_statuses.period_name%TYPE ;
92: v_period_start_dt DATE ;
93: v_period_end_dt DATE ;
94: v_begin_period_name gl_period_statuses.period_name%TYPE ;
95: v_begin_period_start_dt DATE ;
96: v_begin_period_end_dt DATE ;
97: v_begin_period_num gl_period_statuses.period_num%TYPE ;
98: v_cohort_select VARCHAR2(20) ;

Line 97: v_begin_period_num gl_period_statuses.period_num%TYPE ;

93: v_period_end_dt DATE ;
94: v_begin_period_name gl_period_statuses.period_name%TYPE ;
95: v_begin_period_start_dt DATE ;
96: v_begin_period_end_dt DATE ;
97: v_begin_period_num gl_period_statuses.period_num%TYPE ;
98: v_cohort_select VARCHAR2(20) ;
99: v_fiscal_yr VARCHAR2(25);
100: v_dummy_cohort VARCHAR2(25);
101: v_acct_attr_flag VARCHAR2(1) ;

Line 975: FROM gl_period_statuses

971: vc_rpt_fiscal_yr := LPAD(to_char(vp_report_fiscal_yr), 4) ;
972:
973: SELECT to_char(count(*) , '09')
974: INTO vl_fiscal_month_count
975: FROM gl_period_statuses
976: WHERE ledger_id = vp_set_of_books_id
977: AND application_id = 101
978: AND period_year = vp_report_fiscal_yr
979: -- AND adjustment_period_flag = 'N'

Line 1026: FROM gl_period_statuses

1022: INTO v_period_name,
1023: v_period_start_dt,
1024: v_period_end_dt,
1025: vp_report_qtr
1026: FROM gl_period_statuses
1027: WHERE ledger_id = vp_set_of_books_id
1028: AND application_id = 101
1029: AND period_year = vp_report_fiscal_yr
1030: AND period_num = v_period_num ;

Line 1069: FROM gl_period_statuses

1065: INTO v_begin_period_name,
1066: v_begin_period_start_dt,
1067: v_begin_period_end_dt,
1068: v_begin_period_num
1069: FROM gl_period_statuses
1070: WHERE period_num =
1071: (SELECT MIN(period_num)
1072: FROM gl_period_statuses
1073: WHERE period_year = vp_report_fiscal_yr

Line 1072: FROM gl_period_statuses

1068: v_begin_period_num
1069: FROM gl_period_statuses
1070: WHERE period_num =
1071: (SELECT MIN(period_num)
1072: FROM gl_period_statuses
1073: WHERE period_year = vp_report_fiscal_yr
1074: AND ledger_id = vp_set_of_books_id
1075: AND application_id = 101
1076: AND adjustment_period_flag = 'N')

Line 1900: FROM gl_period_statuses

1896:
1897: vl_legis_select :=
1898: vl_legis_select || ' AND gjl.period_name in ' ||
1899: ' ( SELECT period_name
1900: FROM gl_period_statuses
1901: WHERE application_id = 101
1902: AND ledger_id = :set_of_books_id
1903: AND period_num BETWEEN :begin_period_num AND :period_num
1904: AND period_year = :report_fiscal_yr) ' ;

Line 1946: FROM gl_period_statuses

1942: --AND xl.code_combination_id = glcc.code_combination_id
1943: vl_legis_select :=
1944: vl_legis_select || ' AND gjl.period_name in ' ||
1945: ' ( SELECT period_name
1946: FROM gl_period_statuses
1947: WHERE application_id = 101
1948: AND ledger_id = :set_of_books_id
1949: AND period_num BETWEEN :begin_period_num AND :period_num
1950: AND period_year = :report_fiscal_yr) ' ;