APPS.FA_FAS401_XMLP_PKG dependencies on FA_RESERVE_LEDGER_GT

Line 348: operation := 'Inserting into FA_RESERVE_LEDGER_GT';

344: BC.DISTRIBUTION_SOURCE_BOOK,
345: DP.PERIOD_CLOSE_DATE,
346: DP.PERIOD_COUNTER;
347: end if;
348: operation := 'Inserting into FA_RESERVE_LEDGER_GT';
349: -- run only if CRL not installed
350: If (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) then
351: if (h_reporting_flag = 'R') then
352: INSERT INTO FA_RESERVE_LEDGER_GT

Line 352: INSERT INTO FA_RESERVE_LEDGER_GT

348: operation := 'Inserting into FA_RESERVE_LEDGER_GT';
349: -- run only if CRL not installed
350: If (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) then
351: if (h_reporting_flag = 'R') then
352: INSERT INTO FA_RESERVE_LEDGER_GT
353: (ASSET_ID,
354: DH_CCID,
355: DEPRN_RESERVE_ACCT,
356: DATE_PLACED_IN_SERVICE,

Line 509: INSERT INTO FA_RESERVE_LEDGER_GT

505: DH.DATE_EFFECTIVE <= ucd AND
506: nvl(DH.DATE_INEFFECTIVE, sysdate) > tod
507: ;
508: else
509: INSERT INTO FA_RESERVE_LEDGER_GT
510: (ASSET_ID,
511: DH_CCID,
512: DEPRN_RESERVE_ACCT,
513: DATE_PLACED_IN_SERVICE,

Line 670: INSERT INTO FA_RESERVE_LEDGER_GT

666: -- run only if CRL installed
667: elsif (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) then
668: -- Insert Non-Group Details
669: if (h_reporting_flag = 'R') then
670: INSERT INTO FA_RESERVE_LEDGER_GT
671: (ASSET_ID,
672: DH_CCID,
673: DEPRN_RESERVE_ACCT,
674: DATE_PLACED_IN_SERVICE,

Line 764: INSERT INTO FA_RESERVE_LEDGER_GT

760: nvl(DH.DATE_INEFFECTIVE, sysdate) > tod AND
761: -- start cua - exclude the group Assets
762: books.group_asset_id is null;
763: else
764: INSERT INTO FA_RESERVE_LEDGER_GT
765: (ASSET_ID,
766: DH_CCID,
767: DEPRN_RESERVE_ACCT,
768: DATE_PLACED_IN_SERVICE,

Line 861: INSERT INTO FA_RESERVE_LEDGER_GT

857: end if;
858: -- end cua
859: -- Insert the Group Depreciation Details
860: if (h_reporting_flag = 'R') then
861: INSERT INTO FA_RESERVE_LEDGER_GT
862: (ASSET_ID,
863: DH_CCID,
864: DEPRN_RESERVE_ACCT,
865: DATE_PLACED_IN_SERVICE,

Line 934: INSERT INTO FA_RESERVE_LEDGER_GT

930: AND GAR.DATE_EFFECTIVE <= DP.CALENDAR_PERIOD_CLOSE_DATE -- mwoodwar
931: AND nvl(GAR.DATE_INEFFECTIVE, (DP.CALENDAR_PERIOD_CLOSE_DATE + 1))
932: > DP.CALENDAR_PERIOD_CLOSE_DATE; -- mwoodwar
933: else
934: INSERT INTO FA_RESERVE_LEDGER_GT
935: (ASSET_ID,
936: DH_CCID,
937: DEPRN_RESERVE_ACCT,
938: DATE_PLACED_IN_SERVICE,

Line 1009: INSERT INTO FA_RESERVE_LEDGER_GT

1005: > DP.CALENDAR_PERIOD_CLOSE_DATE; -- mwoodwar
1006: end if;
1007: -- Insert the SuperGroup Depreciation Details MPOWELL
1008: if (h_reporting_flag = 'R') then
1009: INSERT INTO FA_RESERVE_LEDGER_GT
1010: (ASSET_ID,
1011: DH_CCID,
1012: DEPRN_RESERVE_ACCT,
1013: DATE_PLACED_IN_SERVICE,

Line 1072: INSERT INTO FA_RESERVE_LEDGER_GT

1068: AND SGR.DATE_EFFECTIVE <= DP.CALENDAR_PERIOD_CLOSE_DATE
1069: AND nvl(SGR.DATE_INEFFECTIVE, (DP.CALENDAR_PERIOD_CLOSE_DATE + 1))
1070: > DP.CALENDAR_PERIOD_CLOSE_DATE;
1071: else
1072: INSERT INTO FA_RESERVE_LEDGER_GT
1073: (ASSET_ID,
1074: DH_CCID,
1075: DEPRN_RESERVE_ACCT,
1076: DATE_PLACED_IN_SERVICE,