DBA Data[Home] [Help]

APPS.FA_SHORT_TAX_YEARS_PKG dependencies on FA_FISCAL_YEAR

Line 88: FROM fa_fiscal_year fy,

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

Line 98: fa_fiscal_year fy

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