DBA Data[Home] [Help]

APPS.FA_SHORT_TAX_YEARS_PKG dependencies on FA_FISCAL_YEAR

Line 87: FROM fa_fiscal_year fy,

83: 0, h_deprn_start_date,
84: decode(h_curr_fy_start_date,
85: NULL,to_date(C_Curr_Fy_Start_Date, 'DD/MM/YYYY'),
86: h_curr_fy_start_date))
87: FROM fa_fiscal_year fy,
88: fa_book_controls bc
89: WHERE h_dpis between fy.start_date
90: and fy.end_date
91: AND bc.book_type_code = X_Book_Type_Code

Line 97: fa_fiscal_year fy

93:
94: CURSOR get_cp_date IS
95: select cp.start_date
96: from fa_calendar_periods cp,
97: fa_fiscal_year fy
98: where cp.calendar_type = h_calendar_type
99: and cp.period_num = X_Current_Period
100: and cp.start_date >= fy.start_date
101: and cp.end_date <= fy.end_date