APPS.FA_FAS400_XMLP_PKG dependencies on FA_RESERVE_LEDGER_GT

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

407: BC.DISTRIBUTION_SOURCE_BOOK,
408: DP.PERIOD_CLOSE_DATE,
409: DP.PERIOD_COUNTER;
410: end if;
411: operation := 'Inserting into FA_RESERVE_LEDGER_GT';
412: -- run only if CRL not installed
413: If (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) then
414: if (h_reporting_flag = 'R') then
415: INSERT INTO FA_RESERVE_LEDGER_GT

Line 415: INSERT INTO FA_RESERVE_LEDGER_GT

411: operation := 'Inserting into FA_RESERVE_LEDGER_GT';
412: -- run only if CRL not installed
413: If (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) then
414: if (h_reporting_flag = 'R') then
415: INSERT INTO FA_RESERVE_LEDGER_GT
416: (ASSET_ID,
417: DH_CCID,
418: DEPRN_RESERVE_ACCT,
419: DATE_PLACED_IN_SERVICE,

Line 572: INSERT INTO FA_RESERVE_LEDGER_GT

568: DH.DATE_EFFECTIVE <= ucd AND
569: nvl(DH.DATE_INEFFECTIVE, sysdate) > tod
570: ;
571: else
572: INSERT INTO FA_RESERVE_LEDGER_GT
573: (ASSET_ID,
574: DH_CCID,
575: DEPRN_RESERVE_ACCT,
576: DATE_PLACED_IN_SERVICE,

Line 733: INSERT INTO FA_RESERVE_LEDGER_GT

729: -- run only if CRL installed
730: elsif (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) then
731: -- Insert Non-Group Details
732: if (h_reporting_flag = 'R') then
733: INSERT INTO FA_RESERVE_LEDGER_GT
734: (ASSET_ID,
735: DH_CCID,
736: DEPRN_RESERVE_ACCT,
737: DATE_PLACED_IN_SERVICE,

Line 827: INSERT INTO FA_RESERVE_LEDGER_GT

823: nvl(DH.DATE_INEFFECTIVE, sysdate) > tod AND
824: -- start cua - exclude the group Assets
825: books.group_asset_id is null;
826: else
827: INSERT INTO FA_RESERVE_LEDGER_GT
828: (ASSET_ID,
829: DH_CCID,
830: DEPRN_RESERVE_ACCT,
831: DATE_PLACED_IN_SERVICE,

Line 924: INSERT INTO FA_RESERVE_LEDGER_GT

920: end if;
921: -- end cua
922: -- Insert the Group Depreciation Details
923: if (h_reporting_flag = 'R') then
924: INSERT INTO FA_RESERVE_LEDGER_GT
925: (ASSET_ID,
926: DH_CCID,
927: DEPRN_RESERVE_ACCT,
928: DATE_PLACED_IN_SERVICE,

Line 997: INSERT INTO FA_RESERVE_LEDGER_GT

993: AND GAR.DATE_EFFECTIVE <= DP.CALENDAR_PERIOD_CLOSE_DATE -- mwoodwar
994: AND nvl(GAR.DATE_INEFFECTIVE, (DP.CALENDAR_PERIOD_CLOSE_DATE + 1))
995: > DP.CALENDAR_PERIOD_CLOSE_DATE; -- mwoodwar
996: else
997: INSERT INTO FA_RESERVE_LEDGER_GT
998: (ASSET_ID,
999: DH_CCID,
1000: DEPRN_RESERVE_ACCT,
1001: DATE_PLACED_IN_SERVICE,

Line 1072: INSERT INTO FA_RESERVE_LEDGER_GT

1068: > DP.CALENDAR_PERIOD_CLOSE_DATE; -- mwoodwar
1069: end if;
1070: -- Insert the SuperGroup Depreciation Details MPOWELL
1071: if (h_reporting_flag = 'R') then
1072: INSERT INTO FA_RESERVE_LEDGER_GT
1073: (ASSET_ID,
1074: DH_CCID,
1075: DEPRN_RESERVE_ACCT,
1076: DATE_PLACED_IN_SERVICE,

Line 1135: INSERT INTO FA_RESERVE_LEDGER_GT

1131: AND SGR.DATE_EFFECTIVE <= DP.CALENDAR_PERIOD_CLOSE_DATE
1132: AND nvl(SGR.DATE_INEFFECTIVE, (DP.CALENDAR_PERIOD_CLOSE_DATE + 1))
1133: > DP.CALENDAR_PERIOD_CLOSE_DATE;
1134: else
1135: INSERT INTO FA_RESERVE_LEDGER_GT
1136: (ASSET_ID,
1137: DH_CCID,
1138: DEPRN_RESERVE_ACCT,
1139: DATE_PLACED_IN_SERVICE,