APPS.FA_JP_TAX_EXTN_PVT dependencies on FA_DEPRN_SUMMARY

Line 1034: , fa_deprn_summary fds

1030: ***********************************************************************/
1031: IS
1032: SELECT CEIL ((fb.COST - fds.deprn_reserve) / 60)
1033: FROM fa_books fb
1034: , fa_deprn_summary fds
1035: WHERE fds.book_type_code = fb.book_type_code
1036: AND fb.asset_id = fds.asset_id
1037: AND fds.period_counter = p_period_counter
1038: AND fb.asset_id = p_asset_id

Line 1161: FROM fa_deprn_summary

1157: SELECT deprn_reserve
1158: INTO ln_acc_deprn
1159: FROM (SELECT ROWNUM a
1160: , deprn_reserve
1161: FROM fa_deprn_summary
1162: WHERE book_type_code = p_book_type_code
1163: AND asset_id = p_asset_id
1164: ORDER BY deprn_reserve DESC)
1165: WHERE ROWNUM = 1;

Line 1169: FROM fa_deprn_summary

1165: WHERE ROWNUM = 1;
1166: */
1167: SELECT max(nvl(deprn_reserve,0))
1168: INTO ln_acc_deprn
1169: FROM fa_deprn_summary
1170: WHERE book_type_code = p_book_type_code
1171: AND asset_id = p_asset_id;
1172: EXCEPTION
1173: WHEN OTHERS

Line 1630: , fa_deprn_summary fds

1626: IS
1627: SELECT CEIL ((fb.COST - fds.deprn_reserve) / 60)
1628: -- need to change for variable
1629: FROM fa_books fb
1630: , fa_deprn_summary fds
1631: WHERE fds.book_type_code = fb.book_type_code
1632: AND fb.asset_id = fds.asset_id
1633: AND fds.period_counter = p_period_counter
1634: AND fb.asset_id = p_asset_id

Line 1872: ln_int_deprn fa_deprn_summary.deprn_reserve%TYPE;

1868: l_date_extn_end DATE;
1869: l_exit NUMBER := 0;
1870: ln_first_elg_period NUMBER;
1871: ln_first_beg_period NUMBER;
1872: ln_int_deprn fa_deprn_summary.deprn_reserve%TYPE;
1873: l_deprn_method fa_books.deprn_method_code%TYPE;
1874: l_amt NUMBER;
1875: l_temp NUMBER;
1876: lr_books lcr_books%ROWTYPE;

Line 2741: FROM fa_deprn_summary

2737: THEN
2738: BEGIN
2739: SELECT COUNT (1)
2740: INTO ln_temp1
2741: FROM fa_deprn_summary
2742: WHERE asset_id = x_asset_id
2743: AND deprn_source_code = 'DEPRN';
2744: END;
2745: IF ln_temp1 = 0

Line 2771: FROM fa_deprn_summary

2767: THEN
2768: BEGIN
2769: SELECT COUNT (1)
2770: INTO ln_temp1
2771: FROM fa_deprn_summary
2772: WHERE asset_id = x_asset_id
2773: AND deprn_source_code = 'DEPRN';
2774: END;
2775:

Line 2853: FROM fa_deprn_summary fds

2849: SELECT deprn_amount
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

Line 3010: FROM fa_deprn_summary fds

3006: THEN
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

Line 3100: FROM fa_deprn_summary fds

3096: SELECT deprn_amount
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

Line 3190: FROM fa_deprn_summary fds

3186: , deprn_reserve
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

Line 3235: FROM fa_deprn_summary fds

3231: SELECT deprn_amount
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