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_FA_AC_EXPORT_PKG dependencies on FA_DEPRN_PERIODS

Line 445: FROM fa_deprn_periods fdp

441: AND fdh.asset_id = faav.asset_id
442: -- Check legal entity
443: AND EXISTS
444: (SELECT fdp.period_close_date
445: FROM fa_deprn_periods fdp
446: WHERE fdp.book_type_code = bk.book_type_code
447: AND fdp.calendar_period_close_date BETWEEN ld_start_date AND
448: ld_end_date
449: AND fdp.period_close_date IS NOT NULL)

Line 452: FROM fa_deprn_periods fdp

448: ld_end_date
449: AND fdp.period_close_date IS NOT NULL)
450: AND fdh.date_effective <
451: nvl((SELECT MAX(fdp.period_close_date)
452: FROM fa_deprn_periods fdp
453: WHERE fdp.book_type_code = bk.book_type_code
454: AND fdp.calendar_period_close_date <= ld_end_date
455: AND fdp.period_close_date IS NOT NULL),
456: SYSDATE)

Line 459: FROM fa_deprn_periods fdp

455: AND fdp.period_close_date IS NOT NULL),
456: SYSDATE)
457: AND (fdh.date_ineffective >
458: nvl((SELECT MAX(fdp.period_close_date)
459: FROM fa_deprn_periods fdp
460: WHERE fdp.book_type_code = bk.book_type_code
461: AND fdp.calendar_period_close_date <= ld_end_date
462: AND fdp.period_close_date IS NOT NULL),
463: SYSDATE) OR fdh.date_ineffective IS NULL)

Line 494: FROM fa_deprn_periods dp

490: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
491: least(SYSDATE,
492: dp.calendar_period_close_date)),
493: dp.calendar_period_open_date)
494: FROM fa_deprn_periods dp
495: WHERE fthv.book_type_code = dp.book_type_code
496: AND fthv.date_effective BETWEEN dp.period_open_date AND
497: nvl(dp.period_close_date, SYSDATE)) <= ld_end_date)
498: ORDER BY faav.asset_number;

Line 653: FROM fa_deprn_periods dp

649: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
650: least(SYSDATE,
651: dp.calendar_period_close_date)),
652: dp.calendar_period_open_date)
653: FROM fa_deprn_periods dp
654: WHERE fthv.book_type_code = dp.book_type_code
655: AND fthv.date_effective BETWEEN dp.period_open_date AND
656: nvl(dp.period_close_date, SYSDATE)) <= ld_end_date);
657: IF (ln_full_retirement_count <> 0) THEN

Line 669: FROM fa_deprn_periods dp

665: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
666: least(SYSDATE,
667: dp.calendar_period_close_date)),
668: dp.calendar_period_open_date)
669: FROM fa_deprn_periods dp
670: WHERE fthv.book_type_code = dp.book_type_code
671: AND fthv.date_effective BETWEEN dp.period_open_date AND
672: nvl(dp.period_close_date, SYSDATE)) <=
673: ld_end_date);

Line 688: FROM fa_deprn_periods dp

684: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
685: least(SYSDATE,
686: dp.calendar_period_close_date)),
687: dp.calendar_period_open_date)
688: FROM fa_deprn_periods dp
689: WHERE fthv.book_type_code = dp.book_type_code
690: AND fthv.date_effective BETWEEN dp.period_open_date AND
691: nvl(dp.period_close_date, SYSDATE)) <=
692: ld_end_date);

Line 704: FROM fa_deprn_periods dp

700: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
701: least(SYSDATE,
702: dp.calendar_period_close_date)),
703: dp.calendar_period_open_date)
704: FROM fa_deprn_periods dp
705: WHERE fthv.book_type_code = dp.book_type_code
706: AND fthv.date_effective BETWEEN dp.period_open_date AND
707: nvl(dp.period_close_date, SYSDATE)) <=
708: ld_end_date);

Line 721: FROM fa_deprn_periods dp

717: ln_row_count := ln_row_count + 1;
718: --get the period counter from depreciation period.
719: SELECT MAX(dp.period_counter)
720: INTO ln_depreciation_counter
721: FROM fa_deprn_periods dp
722: WHERE dp.book_type_code = lv_book_type_code
723: --AND dp.calendar_period_close_date >= ld_end_date
724: AND dp.calendar_period_open_date <= ld_end_date
725: AND dp.period_close_date IS NOT NULL;

Line 742: FROM fa_deprn_periods dp,

738: --check if the asset is adjusted after the to_date.
739: BEGIN
740: SELECT MIN(thv.transaction_header_id)
741: INTO ln_transaction_header_id
742: FROM fa_deprn_periods dp,
743: fa_transaction_history_trx_v thv,
744: fa_transaction_headers fthr
745: WHERE thv.book_type_code = dp.book_type_code
746: AND thv.asset_id = lv_asset_id

Line 792: FROM fa_deprn_periods dp, fa_transaction_history_trx_v thv

788: --tax and coporate books share the same infomration, so we don't need identify the book type.
789: BEGIN
790: SELECT MIN(thv.transaction_header_id)
791: INTO ln_transaction_header_id
792: FROM fa_deprn_periods dp, fa_transaction_history_trx_v thv
793: WHERE asset_id = lv_asset_id
794: AND dp.book_type_code = lv_book_type_code
795: AND transaction_type_code IN ('UNIT ADJUSTMENT', 'RECLASS')
796: AND thv.date_effective BETWEEN dp.period_open_date AND

Line 842: FROM fa_deprn_periods fdp

838: FROM fa_distribution_history fdh
839: WHERE fdh.asset_id = lv_asset_id
840: AND fdh.date_effective <
841: nvl((SELECT MAX(fdp.period_close_date)
842: FROM fa_deprn_periods fdp
843: WHERE fdp.book_type_code = lv_book_type_code
844: AND fdp.calendar_period_close_date <= ld_end_date
845: AND fdp.period_close_date IS NOT NULL),
846: SYSDATE)

Line 849: FROM fa_deprn_periods fdp

845: AND fdp.period_close_date IS NOT NULL),
846: SYSDATE)
847: AND (fdh.date_ineffective >
848: nvl((SELECT MAX(fdp.period_close_date)
849: FROM fa_deprn_periods fdp
850: WHERE fdp.book_type_code = lv_book_type_code
851: AND fdp.calendar_period_close_date <= ld_end_date
852: AND fdp.period_close_date IS NOT NULL),
853: SYSDATE) OR fdh.date_ineffective IS NULL)

Line 876: FROM fa_deprn_periods dp

872: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
873: least(SYSDATE,
874: dp.calendar_period_close_date)),
875: dp.calendar_period_open_date)
876: FROM fa_deprn_periods dp
877: WHERE fthv.book_type_code = dp.book_type_code
878: AND fthv.date_effective BETWEEN dp.period_open_date AND
879: nvl(dp.period_close_date, SYSDATE)) BETWEEN
880: ld_start_date --from date

Line 898: FROM fa_deprn_periods dp

894: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
895: least(SYSDATE,
896: dp.calendar_period_close_date)),
897: dp.calendar_period_open_date)
898: FROM fa_deprn_periods dp
899: WHERE thv.book_type_code = dp.book_type_code
900: AND thv.date_effective BETWEEN
901: dp.period_open_date AND
902: nvl(dp.period_close_date, SYSDATE)) BETWEEN

Line 938: FROM fa_deprn_periods fdp

934: FROM fa_distribution_history fdh
935: WHERE fdh.asset_id = lv_asset_id
936: AND fdh.date_effective <
937: nvl((SELECT MAX(fdp.period_close_date)
938: FROM fa_deprn_periods fdp
939: WHERE fdp.book_type_code = lv_book_type_code
940: AND fdp.calendar_period_close_date <=
941: ld_start_date
942: AND fdp.period_close_date IS NOT NULL),

Line 946: FROM fa_deprn_periods fdp

942: AND fdp.period_close_date IS NOT NULL),
943: SYSDATE)
944: AND (fdh.date_ineffective >
945: nvl((SELECT MAX(fdp.period_close_date)
946: FROM fa_deprn_periods fdp
947: WHERE fdp.book_type_code = lv_book_type_code
948: AND fdp.calendar_period_close_date <=
949: ld_start_date
950: AND fdp.period_close_date IS NOT NULL),

Line 959: FROM fa_deprn_periods fdp

955: FROM fa_distribution_history fdh
956: WHERE fdh.asset_id = lv_asset_id
957: AND fdh.date_effective <
958: nvl((SELECT MAX(fdp.period_close_date)
959: FROM fa_deprn_periods fdp
960: WHERE fdp.book_type_code = lv_book_type_code
961: AND fdp.calendar_period_close_date <=
962: ld_start_date
963: AND fdp.period_close_date IS NOT NULL),

Line 967: FROM fa_deprn_periods fdp

963: AND fdp.period_close_date IS NOT NULL),
964: SYSDATE)
965: AND (fdh.date_ineffective >
966: nvl((SELECT MAX(fdp.period_close_date)
967: FROM fa_deprn_periods fdp
968: WHERE fdp.book_type_code = lv_book_type_code
969: AND fdp.calendar_period_close_date <=
970: ld_start_date
971: AND fdp.period_close_date IS NOT NULL),

Line 1010: FROM fa_deprn_periods fdp, fa_transaction_history_trx_v thv

1006: AND deprn_amount <> 0;
1007: --calculate the depreicated months before addition.
1008: SELECT nvl(fdp.calendar_period_close_date, ld_in_service_date)
1009: INTO ld_addition_date
1010: FROM fa_deprn_periods fdp, fa_transaction_history_trx_v thv
1011: WHERE thv.asset_id = lv_asset_id
1012: AND fdp.book_type_code = lv_book_type_code
1013: AND thv.book_type_code = fdp.book_type_code
1014: AND thv.transaction_type_code = 'ADDITION'