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_DEPRN_PERIODS

Line 37: , p_period_name IN fa_deprn_periods.period_name%TYPE

33: , p_checkbox_check IN VARCHAR2
34: , p_book_type_code IN fa_books.book_type_code%TYPE
35: , p_number_of_periods IN NUMBER
36: , p_asset_id IN fa_books.asset_id%TYPE
37: , p_period_name IN fa_deprn_periods.period_name%TYPE
38: , p_first_begin_prd IN fa_deprn_periods.period_name%TYPE
39: , p_dep_amt IN NUMBER
40: , p_dep_amt_annual IN NUMBER
41: , p_date_placed_in_service IN fa_books.date_placed_in_service%TYPE

Line 38: , p_first_begin_prd IN fa_deprn_periods.period_name%TYPE

34: , p_book_type_code IN fa_books.book_type_code%TYPE
35: , p_number_of_periods IN NUMBER
36: , p_asset_id IN fa_books.asset_id%TYPE
37: , p_period_name IN fa_deprn_periods.period_name%TYPE
38: , p_first_begin_prd IN fa_deprn_periods.period_name%TYPE
39: , p_dep_amt IN NUMBER
40: , p_dep_amt_annual IN NUMBER
41: , p_date_placed_in_service IN fa_books.date_placed_in_service%TYPE
42: , p_life_in_months IN fa_books.life_in_months%TYPE

Line 57: , p_period_name IN fa_deprn_periods.period_name%TYPE

53: )
54: IS
55: CURSOR lcr_deprn_periods (
56: p_book_type_code IN fa_books.book_type_code%TYPE
57: , p_period_name IN fa_deprn_periods.period_name%TYPE
58: )
59: /***********************************************************************
60: *
61: * CURSOR

Line 96: , p_period_name IN fa_deprn_periods.period_name%TYPE

92: AND fcp.period_name = p_period_name;
93:
94: CURSOR lcr_end_date (
95: p_book_type_code IN fa_books.book_type_code%TYPE
96: , p_period_name IN fa_deprn_periods.period_name%TYPE
97: , p_counter IN NUMBER
98: )
99: /***********************************************************************
100: *

Line 179: , p_start_period IN fa_deprn_periods.period_name%TYPE

175: AND fdh.assigned_to = papf.person_id(+);
176:
177: CURSOR lcr_first_periods (
178: p_book_type IN fa_books.book_type_code%TYPE
179: , p_start_period IN fa_deprn_periods.period_name%TYPE
180: , p_number_of_periods IN NUMBER
181: )
182: /***********************************************************************
183: *

Line 272: period_name fa_deprn_periods.period_name%TYPE

268: --
269: -- Record type for whatif
270: --
271: TYPE t_whatif_period_rec IS RECORD (
272: period_name fa_deprn_periods.period_name%TYPE
273: );
274:
275: --
276: -- Table type for for whatif

Line 854: --when Period_counter_fully_reserved is not in FA_deprn_periods table.

850: ***********************************************************************/
851: IS
852:
853: --BUG# 7331249 The Below Query has been changed as, this query is not returning data ,
854: --when Period_counter_fully_reserved is not in FA_deprn_periods table.
855: SELECT fb.book_type_code
856: , cp.period_name
857: , fy.fiscal_year
858: , fb.asset_id

Line 913: , p_period_name IN fa_deprn_periods.period_name%TYPE

909: AND fb.allowed_deprn_limit_amount > 1;
910:
911: CURSOR lcr_deprn_periods (
912: p_book_type_code IN fa_books.book_type_code%TYPE
913: , p_period_name IN fa_deprn_periods.period_name%TYPE
914: )
915: /***********************************************************************
916: *
917: * CURSOR

Line 943: FROM fa_deprn_periods fdp

939: *
940: ***********************************************************************/
941: IS
942: SELECT fdp.period_counter
943: FROM fa_deprn_periods fdp
944: WHERE fdp.book_type_code = p_book_type_code
945: AND fdp.period_name = p_period_name;
946:
947: CURSOR lcr_first_periods (

Line 949: , p_start_period IN fa_deprn_periods.period_name%TYPE

945: AND fdp.period_name = p_period_name;
946:
947: CURSOR lcr_first_periods (
948: p_book_type IN fa_books.book_type_code%TYPE
949: , p_start_period IN fa_deprn_periods.period_name%TYPE
950: , p_number_of_periods IN NUMBER
951: )
952: /***********************************************************************
953: *

Line 1045: , p_period_name IN fa_deprn_periods.period_name%TYPE

1041:
1042: -- condition modified from date_ineffective
1043: CURSOR lcr_end_date (
1044: p_book_type_code IN fa_books.book_type_code%TYPE
1045: , p_period_name IN fa_deprn_periods.period_name%TYPE
1046: , p_counter IN NUMBER
1047: )
1048: /***********************************************************************
1049: *

Line 1136: l_period fa_deprn_periods.period_name%TYPE;

1132: l_end_date DATE;
1133: ln_acc_deprn NUMBER;
1134: ln_first_elg_period NUMBER;
1135: ln_first_beg_period NUMBER;
1136: l_period fa_deprn_periods.period_name%TYPE;
1137: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;
1138: l_period_counter fa_deprn_periods.period_counter%TYPE;
1139: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1140: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;

Line 1138: l_period_counter fa_deprn_periods.period_counter%TYPE;

1134: ln_first_elg_period NUMBER;
1135: ln_first_beg_period NUMBER;
1136: l_period fa_deprn_periods.period_name%TYPE;
1137: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;
1138: l_period_counter fa_deprn_periods.period_counter%TYPE;
1139: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1140: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;
1141: l_period_name fa_deprn_periods.period_name%TYPE;
1142: l_first_eligible_period fa_deprn_periods.period_name%TYPE

Line 1139: l_period_full_counter fa_deprn_periods.period_counter%TYPE;

1135: ln_first_beg_period NUMBER;
1136: l_period fa_deprn_periods.period_name%TYPE;
1137: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;
1138: l_period_counter fa_deprn_periods.period_counter%TYPE;
1139: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1140: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;
1141: l_period_name fa_deprn_periods.period_name%TYPE;
1142: l_first_eligible_period fa_deprn_periods.period_name%TYPE
1143: := NULL;

Line 1140: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;

1136: l_period fa_deprn_periods.period_name%TYPE;
1137: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;
1138: l_period_counter fa_deprn_periods.period_counter%TYPE;
1139: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1140: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;
1141: l_period_name fa_deprn_periods.period_name%TYPE;
1142: l_first_eligible_period fa_deprn_periods.period_name%TYPE
1143: := NULL;
1144: l_deprn_amount NUMBER;

Line 1141: l_period_name fa_deprn_periods.period_name%TYPE;

1137: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;
1138: l_period_counter fa_deprn_periods.period_counter%TYPE;
1139: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1140: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;
1141: l_period_name fa_deprn_periods.period_name%TYPE;
1142: l_first_eligible_period fa_deprn_periods.period_name%TYPE
1143: := NULL;
1144: l_deprn_amount NUMBER;
1145: lr_books lcr_books%ROWTYPE;

Line 1142: l_first_eligible_period fa_deprn_periods.period_name%TYPE

1138: l_period_counter fa_deprn_periods.period_counter%TYPE;
1139: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1140: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;
1141: l_period_name fa_deprn_periods.period_name%TYPE;
1142: l_first_eligible_period fa_deprn_periods.period_name%TYPE
1143: := NULL;
1144: l_deprn_amount NUMBER;
1145: lr_books lcr_books%ROWTYPE;
1146: ex_user_exception EXCEPTION;

Line 1510: , p_period_name IN fa_deprn_periods.period_name%TYPE

1506: AND fb.allowed_deprn_limit_amount > 1;
1507:
1508: CURSOR lcr_deprn_periods (
1509: p_book_type_code IN fa_books.book_type_code%TYPE
1510: , p_period_name IN fa_deprn_periods.period_name%TYPE
1511: )
1512: /***********************************************************************
1513: *
1514: * CURSOR

Line 1540: FROM fa_deprn_periods fdp

1536: *
1537: ***********************************************************************/
1538: IS
1539: SELECT fdp.period_counter
1540: FROM fa_deprn_periods fdp
1541: WHERE fdp.book_type_code = p_book_type_code
1542: AND fdp.period_name = p_period_name;
1543:
1544: CURSOR lcr_first_periods (

Line 1546: , p_start_period IN fa_deprn_periods.period_name%TYPE

1542: AND fdp.period_name = p_period_name;
1543:
1544: CURSOR lcr_first_periods (
1545: p_book_type IN fa_books.book_type_code%TYPE
1546: , p_start_period IN fa_deprn_periods.period_name%TYPE
1547: , p_number_of_periods IN NUMBER
1548: )
1549: /***********************************************************************
1550: *

Line 1641: , p_period_name IN fa_deprn_periods.period_name%TYPE

1637:
1638: -- condition modified from date_ineffective
1639: CURSOR lcr_end_date_check (
1640: p_book_type_code IN fa_books.book_type_code%TYPE
1641: , p_period_name IN fa_deprn_periods.period_name%TYPE
1642: , p_counter IN NUMBER
1643: )
1644: /***********************************************************************
1645: *

Line 1765: , p_period_name IN fa_deprn_periods.period_name%TYPE

1761: AND fcp.end_date = p_end_date;
1762:
1763: CURSOR lcr_extd_deprns (
1764: p_book_type_code IN fa_books.book_type_code%TYPE
1765: , p_period_name IN fa_deprn_periods.period_name%TYPE
1766: )
1767: /***********************************************************************
1768: *
1769: * CURSOR

Line 1854: l_period fa_deprn_periods.period_name%TYPE;

1850: l_end_date_validate DATE;
1851: l_end_date_check DATE;
1852: l_extd_period_name VARCHAR2 (10);
1853: l_extended_date DATE;
1854: l_period fa_deprn_periods.period_name%TYPE;
1855: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;
1856: l_period_counter fa_deprn_periods.period_counter%TYPE;
1857: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1858: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;

Line 1856: l_period_counter fa_deprn_periods.period_counter%TYPE;

1852: l_extd_period_name VARCHAR2 (10);
1853: l_extended_date DATE;
1854: l_period fa_deprn_periods.period_name%TYPE;
1855: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;
1856: l_period_counter fa_deprn_periods.period_counter%TYPE;
1857: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1858: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;
1859: l_period_name fa_deprn_periods.period_name%TYPE;
1860: l_first_eligible_period fa_deprn_periods.period_name%TYPE;

Line 1857: l_period_full_counter fa_deprn_periods.period_counter%TYPE;

1853: l_extended_date DATE;
1854: l_period fa_deprn_periods.period_name%TYPE;
1855: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;
1856: l_period_counter fa_deprn_periods.period_counter%TYPE;
1857: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1858: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;
1859: l_period_name fa_deprn_periods.period_name%TYPE;
1860: l_first_eligible_period fa_deprn_periods.period_name%TYPE;
1861: l_deprn_amount NUMBER;

Line 1858: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;

1854: l_period fa_deprn_periods.period_name%TYPE;
1855: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;
1856: l_period_counter fa_deprn_periods.period_counter%TYPE;
1857: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1858: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;
1859: l_period_name fa_deprn_periods.period_name%TYPE;
1860: l_first_eligible_period fa_deprn_periods.period_name%TYPE;
1861: l_deprn_amount NUMBER;
1862: l_per NUMBER;

Line 1859: l_period_name fa_deprn_periods.period_name%TYPE;

1855: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;
1856: l_period_counter fa_deprn_periods.period_counter%TYPE;
1857: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1858: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;
1859: l_period_name fa_deprn_periods.period_name%TYPE;
1860: l_first_eligible_period fa_deprn_periods.period_name%TYPE;
1861: l_deprn_amount NUMBER;
1862: l_per NUMBER;
1863: l_count NUMBER := 1;

Line 1860: l_first_eligible_period fa_deprn_periods.period_name%TYPE;

1856: l_period_counter fa_deprn_periods.period_counter%TYPE;
1857: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1858: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;
1859: l_period_name fa_deprn_periods.period_name%TYPE;
1860: l_first_eligible_period fa_deprn_periods.period_name%TYPE;
1861: l_deprn_amount NUMBER;
1862: l_per NUMBER;
1863: l_count NUMBER := 1;
1864: ln_acc_deprn NUMBER;

Line 1898: FROM fa_deprn_periods

1894: fnd_profile.VALUE ('FA_JAPAN_TAX_REFORMS');
1895:
1896: SELECT period_name
1897: INTO lc_period
1898: FROM fa_deprn_periods
1899: WHERE book_type_code = p_book_type_code
1900: AND period_close_date IS NULL;
1901:
1902: /* Bug#10311019: Last deprn run period counter */

Line 1908: from fa_deprn_periods

1904: select period_name
1905: into l_last_deprn_run_pc
1906: FROM (
1907: select period_name
1908: from fa_deprn_periods
1909: where book_type_code = p_book_type_code
1910: and deprn_run = 'Y'
1911: order by period_counter desc)
1912: where rownum = 1;

Line 2542: , fa_deprn_periods dp

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

Line 2548: , fa_deprn_periods dp

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
2552: AND cp.calendar_type = bc.deprn_calendar

Line 2574: , fa_deprn_periods dp

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
2578: AND cp.calendar_type = bc.deprn_calendar

Line 2697: FROM fa_deprn_periods

2693:
2694: BEGIN
2695: SELECT period_name
2696: INTO lc_period
2697: FROM fa_deprn_periods
2698: WHERE book_type_code = x_book
2699: AND period_close_date IS NULL;
2700: EXCEPTION
2701: WHEN NO_DATA_FOUND

Line 2854: , fa_deprn_periods fdp

2850: , ROUND (deprn_reserve, 0)
2851: INTO l_dep
2852: , g_dep
2853: FROM fa_deprn_summary fds
2854: , fa_deprn_periods fdp
2855: WHERE fds.period_counter = fdp.period_counter
2856: AND fds.book_type_code = fdp.book_type_code
2857: AND fds.asset_id = x_asset_id
2858: AND fdp.book_type_code = x_book

Line 3011: , fa_deprn_periods fdp

3007: BEGIN
3008: SELECT period_num
3009: INTO l_per_dum
3010: FROM fa_deprn_summary fds
3011: , fa_deprn_periods fdp
3012: WHERE fdp.book_type_code = fds.book_type_code
3013: AND fdp.period_counter = fds.period_counter
3014: AND fds.book_type_code = x_book
3015: AND fds.asset_id = x_asset_id

Line 3101: , fa_deprn_periods fdp

3097: , ROUND (deprn_reserve, 0)
3098: INTO l_dep
3099: , g_dep
3100: FROM fa_deprn_summary fds
3101: , fa_deprn_periods fdp
3102: WHERE fds.period_counter = fdp.period_counter
3103: AND fds.book_type_code = fdp.book_type_code
3104: AND fds.asset_id = x_asset_id
3105: AND fdp.book_type_code = x_book

Line 3149: FROM fa_deprn_periods fdp

3145: ELSE
3146: BEGIN
3147: SELECT fdp.period_counter
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

Line 3191: , fa_deprn_periods fdp

3187: INTO l_dep
3188: , y_dep
3189: , g_dep
3190: FROM fa_deprn_summary fds
3191: , fa_deprn_periods fdp
3192: WHERE fds.period_counter = fdp.period_counter
3193: AND fds.book_type_code = fdp.book_type_code
3194: AND fds.asset_id = x_asset_id
3195: AND fdp.book_type_code = x_book

Line 3236: , fa_deprn_periods fdp

3232: , deprn_reserve
3233: INTO l_dep
3234: , g_dep
3235: FROM fa_deprn_summary fds
3236: , fa_deprn_periods fdp
3237: WHERE fds.period_counter = fdp.period_counter
3238: AND fds.book_type_code = fdp.book_type_code
3239: AND fds.asset_id = x_asset_id
3240: AND fdp.book_type_code = x_book