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.JA_CN_PS_FA_AC_EXP_PKG dependencies on FA_DEPRN_PERIODS

Line 317: FROM fa_deprn_periods fdp

313: -- Check legal entity
314: AND EXISTS
315: (
316: SELECT fdp.period_close_date
317: FROM fa_deprn_periods fdp
318: WHERE fdp.book_type_code = bk.book_type_code
319: AND fdp.calendar_period_close_date
320: BETWEEN ld_start_date AND ld_end_date
321: AND fdp.period_close_date IS NOT NULL

Line 325: FROM fa_deprn_periods fdp

321: AND fdp.period_close_date IS NOT NULL
322: )
323: AND fdh.date_effective < nvl(
324: (SELECT MAX(fdp.period_close_date)
325: FROM fa_deprn_periods fdp
326: WHERE fdp.book_type_code = bk.book_type_code
327: AND fdp.calendar_period_close_date <= ld_end_date
328: AND fdp.period_close_date IS NOT NULL), SYSDATE)
329: AND (fdh.date_ineffective > nvl(

Line 331: FROM fa_deprn_periods fdp

327: AND fdp.calendar_period_close_date <= ld_end_date
328: AND fdp.period_close_date IS NOT NULL), SYSDATE)
329: AND (fdh.date_ineffective > nvl(
330: (SELECT MAX(fdp.period_close_date)
331: FROM fa_deprn_periods fdp
332: WHERE fdp.book_type_code = bk.book_type_code
333: AND fdp.calendar_period_close_date <= ld_end_date
334: AND fdp.period_close_date IS NOT NULL), SYSDATE)
335: OR fdh.date_ineffective IS NULL)

Line 375: FROM fa_deprn_periods dp

371: , least( SYSDATE
372: , dp.calendar_period_close_date)
373: )
374: , dp.calendar_period_open_date)
375: FROM fa_deprn_periods dp
376: WHERE fthv.book_type_code = dp.book_type_code
377: AND fthv.date_effective BETWEEN dp.period_open_date AND
378: nvl(dp.period_close_date, SYSDATE)
379: ) <= ld_end_date

Line 565: FROM fa_deprn_periods dp

561: AND fthv.transaction_type_code = 'FULL RETIREMENT'
562: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
563: least(SYSDATE, dp.calendar_period_close_date)),
564: dp.calendar_period_open_date)
565: FROM fa_deprn_periods dp
566: WHERE fthv.book_type_code = dp.book_type_code
567: AND fthv.date_effective
568: BETWEEN dp.period_open_date
569: AND nvl(dp.period_close_date, SYSDATE)) <= ld_end_date);

Line 584: FROM fa_deprn_periods dp

580: (
581: SELECT greatest(greatest( dp.calendar_period_open_date,
582: least(SYSDATE, dp.calendar_period_close_date)),
583: dp.calendar_period_open_date)
584: FROM fa_deprn_periods dp
585: WHERE fthv.book_type_code = dp.book_type_code
586: AND fthv.date_effective BETWEEN dp.period_open_date
587: AND nvl(dp.period_close_date, SYSDATE)
588: ) <= ld_end_date

Line 608: FROM fa_deprn_periods dp

604: AND fthv.transaction_type_code = 'FULL RETIREMENT'
605: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
606: least(SYSDATE, dp.calendar_period_close_date)),
607: dp.calendar_period_open_date)
608: FROM fa_deprn_periods dp
609: WHERE fthv.book_type_code = dp.book_type_code
610: AND fthv.date_effective BETWEEN dp.period_open_date
611: AND nvl(dp.period_close_date, SYSDATE)) <= ld_end_date);
612: --Retireve the greatest effective date of reinstatement.

Line 625: FROM fa_deprn_periods dp

621: AND fthv.transaction_type_code = 'REINSTATEMENT'
622: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
623: least(SYSDATE, dp.calendar_period_close_date)),
624: dp.calendar_period_open_date)
625: FROM fa_deprn_periods dp
626: WHERE fthv.book_type_code = dp.book_type_code
627: AND fthv.date_effective BETWEEN dp.period_open_date
628: AND nvl(dp.period_close_date, SYSDATE)) <= ld_end_date);
629: IF(ld_retirement_date > ld_reinstated_date)

Line 646: fa_deprn_periods dp

642: MAX(dp.period_counter)
643: INTO
644: ln_depreciation_counter
645: FROM
646: fa_deprn_periods dp
647: WHERE dp.book_type_code = lv_book_type_code
648: AND dp.calendar_period_open_date <= ld_end_date
649: AND dp.period_close_date IS NOT NULL;
650: --get the period counter from depreciation summary.

Line 672: FROM fa_deprn_periods dp

668: SELECT
669: MIN(thv.transaction_header_id)
670: INTO
671: ln_transaction_header_id
672: FROM fa_deprn_periods dp
673: , fa_transaction_history_trx_v thv
674: , fa_transaction_headers fthr
675: WHERE thv.book_type_code = dp.book_type_code
676: AND thv.asset_id = lv_asset_id

Line 730: fa_deprn_periods dp

726: MIN(thv.transaction_header_id)
727: INTO
728: ln_transaction_header_id
729: FROM
730: fa_deprn_periods dp
731: , fa_transaction_history_trx_v thv
732: WHERE asset_id = lv_asset_id
733: AND dp.book_type_code = lv_book_type_code
734: AND transaction_type_code IN('UNIT ADJUSTMENT', 'RECLASS')

Line 787: FROM fa_deprn_periods fdp

783: INTO ln_assigned_unit
784: FROM fa_distribution_history fdh
785: WHERE fdh.asset_id = lv_asset_id
786: AND fdh.date_effective < nvl((SELECT MAX(fdp.period_close_date)
787: FROM fa_deprn_periods fdp
788: WHERE fdp.book_type_code = lv_book_type_code
789: AND fdp.calendar_period_close_date <= ld_end_date
790: AND fdp.period_close_date IS NOT NULL), SYSDATE)
791: AND (fdh.date_ineffective > nvl((SELECT MAX(fdp.period_close_date)

Line 792: FROM fa_deprn_periods fdp

788: WHERE fdp.book_type_code = lv_book_type_code
789: AND fdp.calendar_period_close_date <= ld_end_date
790: AND fdp.period_close_date IS NOT NULL), SYSDATE)
791: AND (fdh.date_ineffective > nvl((SELECT MAX(fdp.period_close_date)
792: FROM fa_deprn_periods fdp
793: WHERE fdp.book_type_code = lv_book_type_code
794: AND fdp.calendar_period_close_date <= ld_end_date
795: AND fdp.period_close_date IS NOT NULL), SYSDATE)
796: OR fdh.date_ineffective IS NULL)

Line 820: FROM fa_deprn_periods dp

816: AND
817: ((SELECT greatest(greatest(dp.calendar_period_open_date,
818: least(SYSDATE, dp.calendar_period_close_date)),
819: dp.calendar_period_open_date)
820: FROM fa_deprn_periods dp
821: WHERE fthv.book_type_code = dp.book_type_code
822: AND fthv.date_effective BETWEEN dp.period_open_date AND
823: nvl(dp.period_close_date, SYSDATE))
824: BETWEEN ld_start_date --from date

Line 843: FROM fa_deprn_periods dp

839: AND(
840: (SELECT greatest(greatest(dp.calendar_period_open_date,
841: least(SYSDATE, dp.calendar_period_close_date)),
842: dp.calendar_period_open_date)
843: FROM fa_deprn_periods dp
844: WHERE thv.book_type_code = dp.book_type_code
845: AND thv.date_effective BETWEEN dp.period_open_date AND
846: nvl(dp.period_close_date, SYSDATE))
847: BETWEEN ld_start_date --from date

Line 884: FROM fa_deprn_periods fdp

880: FROM fa_distribution_history fdh
881: WHERE fdh.asset_id = lv_asset_id
882: AND fdh.date_effective < nvl(
883: (SELECT MAX(fdp.period_close_date)
884: FROM fa_deprn_periods fdp
885: WHERE fdp.book_type_code = lv_book_type_code
886: AND fdp.calendar_period_close_date <= ld_start_date
887: AND fdp.period_close_date IS NOT NULL), SYSDATE)
888: AND (fdh.date_ineffective > nvl(

Line 890: FROM fa_deprn_periods fdp

886: AND fdp.calendar_period_close_date <= ld_start_date
887: AND fdp.period_close_date IS NOT NULL), SYSDATE)
888: AND (fdh.date_ineffective > nvl(
889: (SELECT MAX(fdp.period_close_date)
890: FROM fa_deprn_periods fdp
891: WHERE fdp.book_type_code = lv_book_type_code
892: AND fdp.calendar_period_close_date <= ld_start_date
893: AND fdp.period_close_date IS NOT NULL), SYSDATE)
894: OR fdh.date_ineffective IS NULL);

Line 901: FROM fa_deprn_periods fdp

897: INTO ln_assigned_unit
898: FROM fa_distribution_history fdh
899: WHERE fdh.asset_id = lv_asset_id
900: AND fdh.date_effective < nvl((SELECT MAX(fdp.period_close_date)
901: FROM fa_deprn_periods fdp
902: WHERE fdp.book_type_code = lv_book_type_code
903: AND fdp.calendar_period_close_date <= ld_start_date
904: AND fdp.period_close_date IS NOT NULL), SYSDATE)
905: AND (fdh.date_ineffective > nvl((SELECT MAX(fdp.period_close_date)

Line 906: FROM fa_deprn_periods fdp

902: WHERE fdp.book_type_code = lv_book_type_code
903: AND fdp.calendar_period_close_date <= ld_start_date
904: AND fdp.period_close_date IS NOT NULL), SYSDATE)
905: AND (fdh.date_ineffective > nvl((SELECT MAX(fdp.period_close_date)
906: FROM fa_deprn_periods fdp
907: WHERE fdp.book_type_code = lv_book_type_code
908: AND fdp.calendar_period_close_date <= ld_start_date
909: AND fdp.period_close_date IS NOT NULL), SYSDATE)
910: OR fdh.date_ineffective IS NULL)

Line 949: FROM fa_deprn_periods fdp,

945: AND deprn_amount <> 0;
946: --calculate the depreicated months before addition.
947: SELECT nvl(fdp.calendar_period_close_date, ld_in_service_date)
948: INTO ld_addition_date
949: FROM fa_deprn_periods fdp,
950: fa_transaction_history_trx_v thv
951: WHERE thv.asset_id = lv_asset_id
952: AND fdp.book_type_code = lv_book_type_code
953: AND thv.book_type_code = fdp.book_type_code