DBA Data[Home] [Help]

APPS.FA_SHORT_TAX_YEARS_PKG dependencies on FA_CALENDAR_PERIODS

Line 66: , fa_calendar_periods cp

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

Line 97: from fa_calendar_periods cp,

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