DBA Data[Home] [Help]

APPS.FA_SHORT_TAX_YEARS_PKG dependencies on FA_CALENDAR_PERIODS

Line 65: , fa_calendar_periods cp

61: -- Bug4169773
62: Cursor c_get_trx_date is
63: select cp.start_date trx_date
64: from fa_transaction_headers th
65: , fa_calendar_periods cp
66: where th.asset_id = X_Asset_Id
67: and th.book_type_code = X_Book_Type_Code
68: and cp.calendar_type = h_calendar_type
69: and nvl(th.amortization_start_date, th.transaction_date_entered)

Line 96: from fa_calendar_periods cp,

92: AND bc.fiscal_year_name = fy.fiscal_year_name;
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