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_CALENDAR_PERIODS

Line 86: FROM fa_calendar_periods fcp

82: *
83: ***********************************************************************/
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

Line 127: FROM fa_calendar_periods fcp

123: *
124: ***********************************************************************/
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

Line 211: FROM fa_calendar_periods cp

207: *
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

Line 215: , fa_calendar_periods cp1

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
218: AND fb.book_type_code = p_book_type
219: AND cp.calendar_type = fc.calendar_type

Line 260: FROM fa_calendar_periods fcp

256: *
257: ***********************************************************************/
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

Line 298: l_greater_period fa_calendar_periods.period_name%TYPE;

294: l_first_eligible_period VARCHAR2 (15);
295: l_start_period_name VARCHAR2 (15);
296: l_period NUMBER;
297: l_twelve_count NUMBER;
298: l_greater_period fa_calendar_periods.period_name%TYPE;
299: -- As per Bug 712836
300: l_whatif_period_tbl t_whatif_period_tbl;
301: l_whatif_period_tbl2 t_whatif_period_tbl;
302: l_end_date fa_calendar_periods.end_date%TYPE;

Line 302: l_end_date fa_calendar_periods.end_date%TYPE;

298: l_greater_period fa_calendar_periods.period_name%TYPE;
299: -- As per Bug 712836
300: l_whatif_period_tbl t_whatif_period_tbl;
301: l_whatif_period_tbl2 t_whatif_period_tbl;
302: l_end_date fa_calendar_periods.end_date%TYPE;
303: h_asset_id NUMBER;
304: lr_distribution lcr_distribution%ROWTYPE;
305: BEGIN
306: l_whatif_period_tbl2.DELETE;

Line 450: FROM fa_calendar_periods FCP

446: AND p_flag = 'N'
447: THEN
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

Line 584: FROM fa_calendar_periods FCP

580: END IF; -- IF p_period_name <> p_first_begin_prd THEN
581:
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

Line 879: ,fa_calendar_periods cp

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
883: , fa_distribution_history fdh

Line 983: FROM fa_calendar_periods cp

979: IS
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

Line 987: , fa_calendar_periods cp1

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
990: AND fb.book_type_code = p_book_type
991: AND cp.calendar_type = fc.calendar_type

Line 1076: FROM fa_calendar_periods fcp

1072: *
1073: ***********************************************************************/
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

Line 1116: FROM fa_calendar_periods fcp

1112: *
1113: ***********************************************************************/
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

Line 1578: FROM fa_calendar_periods cp

1574: *
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

Line 1582: , fa_calendar_periods cp1

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
1585: AND fb.book_type_code = p_book_type
1586: AND cp.calendar_type = fc.calendar_type

Line 1673: FROM fa_calendar_periods fcp

1669: *
1670: ***********************************************************************/
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

Line 1683: , p_end_date IN fa_calendar_periods.end_date%TYPE

1679: AND fcp.period_name = p_period_name;
1680:
1681: CURSOR lcr_end_date_validate (
1682: p_book_type_code IN fa_books.book_type_code%TYPE
1683: , p_end_date IN fa_calendar_periods.end_date%TYPE
1684: , p_counter IN NUMBER
1685: )
1686: /***********************************************************************
1687: *

Line 1715: FROM fa_calendar_periods fcp

1711: *
1712: ***********************************************************************/
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

Line 1755: FROM fa_calendar_periods fcp

1751: *
1752: ***********************************************************************/
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

Line 1794: FROM fa_calendar_periods fcp

1790: *
1791: ***********************************************************************/
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

Line 2540: FROM fa_calendar_periods cp

2536: , fa_jp_tax_extn_pvt.ret_counter (x_book_type, cp1.period_name)
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

Line 2543: , fa_calendar_periods cp1

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
2546: , fa_calendar_periods cp1
2547: , fa_book_controls bc

Line 2545: 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
2546: , fa_calendar_periods cp1
2547: , fa_book_controls bc
2548: , fa_deprn_periods dp
2549: WHERE dp.book_type_code = x_book_type

Line 2546: , fa_calendar_periods cp1

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
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

Line 2573: FROM fa_calendar_periods cp

2569: x_book_type VARCHAR2
2570: )
2571: IS
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

Line 2709: FROM fa_calendar_periods fc

2705:
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'))

Line 2861: FROM fa_calendar_periods cp

2857: AND fds.asset_id = x_asset_id
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

Line 2870: FROM fa_calendar_periods cp

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

Line 3108: FROM fa_calendar_periods cp

3104: AND fds.asset_id = x_asset_id
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

Line 3118: FROM fa_calendar_periods cp

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

Line 3152: FROM fa_calendar_periods cp

3148: INTO ln_stcnt
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

Line 3163: FROM fa_calendar_periods cp

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

Line 3243: FROM fa_calendar_periods cp

3239: AND fds.asset_id = x_asset_id
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

Line 3253: FROM fa_calendar_periods cp

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

Line 3507: FROM fa_calendar_periods fc

3503: h_periodnum NUMBER;
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;

Line 3532: FROM fa_calendar_periods fc

3528: BEGIN
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