eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_JP_TAX_EXTN_PVT dependencies on FA_FISCAL_YEAR

Line 212: , fa_fiscal_year fy

208: ***********************************************************************/
209: IS
210: SELECT cp1.period_name
211: FROM fa_calendar_periods cp
212: , fa_fiscal_year fy
213: , fa_book_controls fb
214: , fa_calendar_types fc
215: , fa_calendar_periods cp1
216: WHERE cp.period_name = p_start_period

Line 880: , fa_fiscal_year fy

876: , (fb.allowed_deprn_limit_amount - 1) / 5 annual_deprn_value
877: FROM fa_books fb
878: , fa_book_controls fbc
879: ,fa_calendar_periods cp
880: , fa_fiscal_year fy
881: , fa_calendar_types fct
882: , fa_additions fa
883: , fa_distribution_history fdh
884: , fa_locations_kfv flk

Line 984: , fa_fiscal_year fy

980: --As per Bug No. 7289893 . The SQL statement was failing if p_number_of_periods = 1
981:
982: SELECT cp1.period_name
983: FROM fa_calendar_periods cp
984: , fa_fiscal_year fy
985: , fa_book_controls fb
986: , fa_calendar_types fc
987: , fa_calendar_periods cp1
988: WHERE cp.period_name = p_start_period

Line 1579: , fa_fiscal_year fy

1575: ***********************************************************************/
1576: IS
1577: SELECT cp1.period_name
1578: FROM fa_calendar_periods cp
1579: , fa_fiscal_year fy
1580: , fa_book_controls fb
1581: , fa_calendar_types fc
1582: , fa_calendar_periods cp1
1583: WHERE cp.period_name = p_start_period

Line 2862: , fa_fiscal_year fy

2858: AND fdp.book_type_code = x_book
2859: AND fdp.period_name =
2860: (SELECT cp.period_name
2861: FROM fa_calendar_periods cp
2862: , fa_fiscal_year fy
2863: , fa_book_controls fb
2864: WHERE cp.calendar_type = fb.deprn_calendar
2865: AND fb.book_type_code = x_book
2866: AND fb.fiscal_year_name = fy.fiscal_year_name

Line 2871: , fa_fiscal_year fy

2867: AND cp.period_num = 1
2868: AND fy.fiscal_year =
2869: (SELECT fy.fiscal_year
2870: FROM fa_calendar_periods cp
2871: , fa_fiscal_year fy
2872: , fa_book_controls fb
2873: WHERE cp.period_name = lc_period
2874: AND cp.calendar_type =
2875: fb.deprn_calendar

Line 3109: , fa_fiscal_year fy

3105: AND fdp.book_type_code = x_book
3106: AND fdp.period_name =
3107: (SELECT cp.period_name
3108: FROM fa_calendar_periods cp
3109: , fa_fiscal_year fy
3110: , fa_book_controls fb
3111: WHERE cp.calendar_type = fb.deprn_calendar
3112: AND fb.book_type_code = x_book
3113: AND fb.fiscal_year_name =

Line 3119: , fa_fiscal_year fy

3115: AND cp.period_num = 1
3116: AND fy.fiscal_year =
3117: (SELECT fy.fiscal_year
3118: FROM fa_calendar_periods cp
3119: , fa_fiscal_year fy
3120: , fa_book_controls fb
3121: WHERE cp.period_name =
3122: lc_period
3123: AND cp.calendar_type =

Line 3153: , fa_fiscal_year fy

3149: FROM fa_deprn_periods fdp
3150: WHERE fdp.period_name =
3151: (SELECT cp.period_name
3152: FROM fa_calendar_periods cp
3153: , fa_fiscal_year fy
3154: , fa_book_controls fb
3155: WHERE cp.calendar_type =
3156: fb.deprn_calendar
3157: AND fb.book_type_code = x_book

Line 3164: , fa_fiscal_year fy

3160: AND cp.period_num = 1
3161: AND fy.fiscal_year =
3162: (SELECT fy.fiscal_year
3163: FROM fa_calendar_periods cp
3164: , fa_fiscal_year fy
3165: , fa_book_controls fb
3166: WHERE cp.period_name =
3167: lc_period
3168: AND cp.calendar_type =

Line 3244: , fa_fiscal_year fy

3240: AND fdp.book_type_code = x_book
3241: AND fdp.period_name =
3242: (SELECT cp.period_name
3243: FROM fa_calendar_periods cp
3244: , fa_fiscal_year fy
3245: , fa_book_controls fb
3246: WHERE cp.calendar_type = fb.deprn_calendar
3247: AND fb.book_type_code = x_book
3248: AND fb.fiscal_year_name =

Line 3254: , fa_fiscal_year fy

3250: AND cp.period_num = 1
3251: AND fy.fiscal_year =
3252: (SELECT fy.fiscal_year
3253: FROM fa_calendar_periods cp
3254: , fa_fiscal_year fy
3255: , fa_book_controls fb
3256: WHERE cp.period_name =
3257: lc_period
3258: AND cp.calendar_type =

Line 3534: , fa_fiscal_year ffy

3530: period_counter
3531: INTO l_dtcntr1
3532: FROM fa_calendar_periods fc
3533: , fa_book_controls fb
3534: , fa_fiscal_year ffy
3535: , fa_calendar_types fct
3536: WHERE fc.calendar_type = fb.deprn_calendar
3537: AND fb.book_type_code = x_book_typ
3538: AND ffy.fiscal_year_name = fb.fiscal_year_name