APPS.FA_FAS480_XMLP_PKG dependencies on FA_RESERVE_LEDGER_GT

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

420: BC.DISTRIBUTION_SOURCE_BOOK,
421: DP.PERIOD_CLOSE_DATE,
422: DP.PERIOD_COUNTER;
423: end if;
424: operation := 'Inserting into FA_RESERVE_LEDGER_GT';
425: -- run only if CRL not installed
426: If (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) then
427: if (h_reporting_flag = 'R') then
428: INSERT INTO FA_RESERVE_LEDGER_GT

Line 428: INSERT INTO FA_RESERVE_LEDGER_GT

424: operation := 'Inserting into FA_RESERVE_LEDGER_GT';
425: -- run only if CRL not installed
426: If (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) then
427: if (h_reporting_flag = 'R') then
428: INSERT INTO FA_RESERVE_LEDGER_GT
429: (ASSET_ID,
430: DH_CCID,
431: DEPRN_RESERVE_ACCT,
432: DATE_PLACED_IN_SERVICE,

Line 585: INSERT INTO FA_RESERVE_LEDGER_GT

581: DH.DATE_EFFECTIVE <= ucd AND
582: nvl(DH.DATE_INEFFECTIVE, sysdate) > tod
583: ;
584: else
585: INSERT INTO FA_RESERVE_LEDGER_GT
586: (ASSET_ID,
587: DH_CCID,
588: DEPRN_RESERVE_ACCT,
589: DATE_PLACED_IN_SERVICE,

Line 746: INSERT INTO FA_RESERVE_LEDGER_GT

742: -- run only if CRL installed
743: elsif (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) then
744: -- Insert Non-Group Details
745: if (h_reporting_flag = 'R') then
746: INSERT INTO FA_RESERVE_LEDGER_GT
747: (ASSET_ID,
748: DH_CCID,
749: DEPRN_RESERVE_ACCT,
750: DATE_PLACED_IN_SERVICE,

Line 840: INSERT INTO FA_RESERVE_LEDGER_GT

836: nvl(DH.DATE_INEFFECTIVE, sysdate) > tod AND
837: -- start cua - exclude the group Assets
838: books.group_asset_id is null;
839: else
840: INSERT INTO FA_RESERVE_LEDGER_GT
841: (ASSET_ID,
842: DH_CCID,
843: DEPRN_RESERVE_ACCT,
844: DATE_PLACED_IN_SERVICE,

Line 937: INSERT INTO FA_RESERVE_LEDGER_GT

933: end if;
934: -- end cua
935: -- Insert the Group Depreciation Details
936: if (h_reporting_flag = 'R') then
937: INSERT INTO FA_RESERVE_LEDGER_GT
938: (ASSET_ID,
939: DH_CCID,
940: DEPRN_RESERVE_ACCT,
941: DATE_PLACED_IN_SERVICE,

Line 1010: INSERT INTO FA_RESERVE_LEDGER_GT

1006: AND GAR.DATE_EFFECTIVE <= DP.CALENDAR_PERIOD_CLOSE_DATE -- mwoodwar
1007: AND nvl(GAR.DATE_INEFFECTIVE, (DP.CALENDAR_PERIOD_CLOSE_DATE + 1))
1008: > DP.CALENDAR_PERIOD_CLOSE_DATE; -- mwoodwar
1009: else
1010: INSERT INTO FA_RESERVE_LEDGER_GT
1011: (ASSET_ID,
1012: DH_CCID,
1013: DEPRN_RESERVE_ACCT,
1014: DATE_PLACED_IN_SERVICE,

Line 1085: INSERT INTO FA_RESERVE_LEDGER_GT

1081: > DP.CALENDAR_PERIOD_CLOSE_DATE; -- mwoodwar
1082: end if;
1083: -- Insert the SuperGroup Depreciation Details MPOWELL
1084: if (h_reporting_flag = 'R') then
1085: INSERT INTO FA_RESERVE_LEDGER_GT
1086: (ASSET_ID,
1087: DH_CCID,
1088: DEPRN_RESERVE_ACCT,
1089: DATE_PLACED_IN_SERVICE,

Line 1148: INSERT INTO FA_RESERVE_LEDGER_GT

1144: AND SGR.DATE_EFFECTIVE <= DP.CALENDAR_PERIOD_CLOSE_DATE
1145: AND nvl(SGR.DATE_INEFFECTIVE, (DP.CALENDAR_PERIOD_CLOSE_DATE + 1))
1146: > DP.CALENDAR_PERIOD_CLOSE_DATE;
1147: else
1148: INSERT INTO FA_RESERVE_LEDGER_GT
1149: (ASSET_ID,
1150: DH_CCID,
1151: DEPRN_RESERVE_ACCT,
1152: DATE_PLACED_IN_SERVICE,