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_BOOK_CONTROLS

Line 88: , fa_book_controls fbc

84: IS
85: SELECT fcp.end_date
86: FROM fa_calendar_periods fcp
87: , fa_calendar_types fct
88: , fa_book_controls fbc
89: WHERE fbc.book_type_code = p_book_type_code
90: AND fcp.calendar_type = fct.calendar_type
91: AND fcp.calendar_type = fbc.deprn_calendar
92: AND fcp.period_name = p_period_name;

Line 129: , fa_book_controls fbc

125: IS
126: SELECT LAST_DAY (ADD_MONTHS (fcp.end_date, p_counter))
127: FROM fa_calendar_periods fcp
128: , fa_calendar_types fct
129: , fa_book_controls fbc
130: WHERE fbc.book_type_code = p_book_type_code
131: AND fcp.calendar_type = fct.calendar_type
132: AND fcp.calendar_type = fbc.deprn_calendar
133: AND fcp.period_name = p_period_name;

Line 171: , fa_book_controls fbc

167: , papf.full_name
168: , papf.employee_number
169: FROM fa_distribution_history fdh
170: , per_all_people_f papf
171: , fa_book_controls fbc
172: WHERE fbc.book_type_code = p_book_type_code
173: AND fdh.book_type_code = fbc.distribution_source_book
174: AND fdh.asset_id = p_asset_id
175: AND fdh.assigned_to = papf.person_id(+);

Line 213: , fa_book_controls fb

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
217: AND cp.calendar_type = fb.deprn_calendar

Line 262: , fa_book_controls fbc

258: IS
259: SELECT fcp.period_name
260: FROM fa_calendar_periods fcp
261: , fa_calendar_types fct
262: , fa_book_controls fbc
263: WHERE fbc.book_type_code = p_book_type_code
264: AND fcp.calendar_type = fct.calendar_type
265: AND fcp.calendar_type = fbc.deprn_calendar
266: AND fcp.end_date = p_end_date;

Line 452: , fa_book_controls FBC

448: l_sql_query :=
449: 'SELECT FCP.period_name
450: FROM fa_calendar_periods FCP
451: , fa_calendar_types FCT
452: , fa_book_controls FBC
453: WHERE FBC.book_type_code = '''
454: || p_book_type_code
455: || '''
456: AND FCP.calendar_type = FCT.calendar_type

Line 586: , fa_book_controls FBC

582: l_sql_query2 :=
583: 'SELECT FCP.period_name
584: FROM fa_calendar_periods FCP
585: , fa_calendar_types FCT
586: , fa_book_controls FBC
587: WHERE FBC.book_type_code = '''
588: || p_book_type_code
589: || '''
590: AND FCP.calendar_type = FCT.calendar_type

Line 878: , fa_book_controls fbc

874: -- , CEIL(((FB.cost - FB.salvage_value)*FB.basic_rate)/12) Deprn_Value
875: , ROUND ((fb.allowed_deprn_limit_amount - 1) / 60) deprn_value
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

Line 985: , fa_book_controls fb

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
989: AND cp.calendar_type = fb.deprn_calendar

Line 1078: , fa_book_controls fbc

1074: IS
1075: SELECT LAST_DAY (ADD_MONTHS (fcp.end_date, p_counter))
1076: FROM fa_calendar_periods fcp
1077: , fa_calendar_types fct
1078: , fa_book_controls fbc
1079: WHERE fbc.book_type_code = p_book_type_code
1080: AND fcp.calendar_type = fct.calendar_type
1081: AND fcp.calendar_type = fbc.deprn_calendar
1082: AND fcp.period_name = p_period_name;

Line 1118: , fa_book_controls fbc

1114: IS
1115: SELECT fcp.period_name
1116: FROM fa_calendar_periods fcp
1117: , fa_calendar_types fct
1118: , fa_book_controls fbc
1119: WHERE fbc.book_type_code = p_book_type_code
1120: AND fcp.calendar_type = fct.calendar_type
1121: AND fcp.calendar_type = fbc.deprn_calendar
1122: AND fcp.end_date = p_end_date;

Line 1125: l_sob fa_book_controls.set_of_books_id%TYPE;

1121: AND fcp.calendar_type = fbc.deprn_calendar
1122: AND fcp.end_date = p_end_date;
1123:
1124: l_req_id fa_whatif_itf.request_id%TYPE;
1125: l_sob fa_book_controls.set_of_books_id%TYPE;
1126: l_fully_reserved_flag VARCHAR2 (1);
1127: lc_return BOOLEAN;
1128: l_profile_tax_reform VARCHAR2 (100);
1129: ln_setof_bk_id NUMBER;

Line 1484: , fa_book_controls fbc -- As per Bug No .7183390 (For Tax Books)

1480: , (fb.allowed_deprn_limit_amount - 1) / 5 annual_deprn_value
1481: , fb.adjusted_cost
1482: , fb.allowed_deprn_limit_amount
1483: FROM fa_books fb
1484: , fa_book_controls fbc -- As per Bug No .7183390 (For Tax Books)
1485: , fa_additions fa
1486: , fa_distribution_history fdh
1487: , fa_locations_kfv flk
1488: , gl_code_combinations_kfv gcck

Line 1580: , fa_book_controls fb

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
1584: AND cp.calendar_type = fb.deprn_calendar

Line 1675: , fa_book_controls fbc

1671: IS
1672: SELECT LAST_DAY (ADD_MONTHS (fcp.end_date, p_counter))
1673: FROM fa_calendar_periods fcp
1674: , fa_calendar_types fct
1675: , fa_book_controls fbc
1676: WHERE fbc.book_type_code = p_book_type_code
1677: AND fcp.calendar_type = fct.calendar_type
1678: AND fcp.calendar_type = fbc.deprn_calendar
1679: AND fcp.period_name = p_period_name;

Line 1717: , fa_book_controls fbc

1713: IS
1714: SELECT LAST_DAY (ADD_MONTHS (fcp.end_date, p_counter))
1715: FROM fa_calendar_periods fcp
1716: , fa_calendar_types fct
1717: , fa_book_controls fbc
1718: WHERE fbc.book_type_code = p_book_type_code
1719: AND fcp.calendar_type = fct.calendar_type
1720: AND fcp.calendar_type = fbc.deprn_calendar
1721: AND p_end_date BETWEEN fcp.start_date AND fcp.end_date;

Line 1757: , fa_book_controls fbc

1753: IS
1754: SELECT fcp.period_name
1755: FROM fa_calendar_periods fcp
1756: , fa_calendar_types fct
1757: , fa_book_controls fbc
1758: WHERE fbc.book_type_code = p_book_type_code
1759: AND fcp.calendar_type = fct.calendar_type
1760: AND fcp.calendar_type = fbc.deprn_calendar
1761: AND fcp.end_date = p_end_date;

Line 1796: , fa_book_controls fbc

1792: IS
1793: SELECT fcp.end_date
1794: FROM fa_calendar_periods fcp
1795: , fa_calendar_types fct
1796: , fa_book_controls fbc
1797: WHERE fbc.book_type_code = p_book_type_code
1798: AND fcp.calendar_type = fct.calendar_type
1799: AND fcp.calendar_type = fbc.deprn_calendar
1800: AND fcp.period_name = p_period_name;

Line 1842: l_sob fa_book_controls.set_of_books_id%TYPE;

1838: AND fb.transaction_header_id_out IS NULL
1839: AND fb.deprn_method_code LIKE '%STL%';
1840:
1841: l_req_id fa_whatif_itf.request_id%TYPE;
1842: l_sob fa_book_controls.set_of_books_id%TYPE;
1843: l_fully_reserved_flag VARCHAR2 (1);
1844: lc_return BOOLEAN;
1845: l_profile_tax_reform VARCHAR2 (100);
1846: ln_setof_bk_id NUMBER;

Line 2541: , fa_book_controls bc

2537: counter
2538: , cp1.period_num
2539: , bc.fiscal_year_name
2540: FROM fa_calendar_periods cp
2541: , fa_book_controls bc
2542: , fa_deprn_periods dp
2543: , fa_calendar_periods cp1
2544: , (SELECT MAX (cp.start_date) max_start_date
2545: FROM fa_calendar_periods cp

Line 2547: , fa_book_controls bc

2543: , fa_calendar_periods cp1
2544: , (SELECT MAX (cp.start_date) max_start_date
2545: FROM fa_calendar_periods cp
2546: , fa_calendar_periods cp1
2547: , fa_book_controls bc
2548: , fa_deprn_periods dp
2549: WHERE dp.book_type_code = x_book_type
2550: AND dp.period_close_date IS NULL
2551: AND dp.calendar_period_open_date <= cp.start_date

Line 2576: , fa_book_controls bc

2572: SELECT th.asset_id
2573: FROM fa_calendar_periods cp
2574: , fa_deprn_periods dp
2575: , fa_transaction_headers th
2576: , fa_book_controls bc
2577: WHERE dp.book_type_code = bc.book_type_code
2578: AND cp.calendar_type = bc.deprn_calendar
2579: AND th.book_type_code = dp.book_type_code
2580: AND th.transaction_date_entered BETWEEN cp.start_date AND cp.end_date

Line 2656: , fa_book_controls fb

2652: BEGIN
2653: SELECT number_per_fiscal_year
2654: INTO h_nop
2655: FROM fa_calendar_types fc
2656: , fa_book_controls fb
2657: WHERE fc.calendar_type = fb.deprn_calendar
2658: AND fb.book_type_code = x_book;
2659: END;
2660:

Line 2710: , fa_book_controls fb

2706: BEGIN
2707: SELECT fc.period_name
2708: INTO l_dtin_serv
2709: FROM fa_calendar_periods fc
2710: , fa_book_controls fb
2711: WHERE fc.calendar_type = fb.deprn_calendar
2712: AND fb.book_type_code = x_book
2713: AND TRUNC (TO_DATE (x_dtin_serv, 'dd/mm/rrrr'))
2714: BETWEEN fc.start_date

Line 2863: , fa_book_controls fb

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
2867: AND cp.period_num = 1

Line 2872: , fa_book_controls fb

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
2876: AND fb.book_type_code = x_book

Line 3110: , fa_book_controls fb

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 =
3114: fy.fiscal_year_name

Line 3120: , fa_book_controls fb

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 =
3124: fb.deprn_calendar

Line 3154: , fa_book_controls fb

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
3158: AND fb.fiscal_year_name =

Line 3165: , fa_book_controls fb

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 =
3169: fb.deprn_calendar

Line 3245: , fa_book_controls fb

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 =
3249: fy.fiscal_year_name

Line 3255: , fa_book_controls fb

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 =
3259: fb.deprn_calendar

Line 3508: , fa_book_controls fb

3504: BEGIN
3505: SELECT period_num
3506: INTO h_periodnum
3507: FROM fa_calendar_periods fc
3508: , fa_book_controls fb
3509: WHERE fc.calendar_type = fb.deprn_calendar
3510: AND fb.book_type_code = x_book_type
3511: AND period_name = x_period;
3512:

Line 3533: , fa_book_controls fb

3529: SELECT (ffy.fiscal_year * fct.number_per_fiscal_year + fc.period_num)
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