APPS.FA_FAS403_XMLP_PKG dependencies on FA_RESERVE_LEDGER_GT

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

384: BC.DISTRIBUTION_SOURCE_BOOK,
385: DP.PERIOD_CLOSE_DATE,
386: DP.PERIOD_COUNTER;
387: end if;
388: operation := 'Inserting into FA_RESERVE_LEDGER_GT';
389: -- run only if CRL not installed
390: If (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) then
391: if (h_reporting_flag = 'R') then
392: INSERT INTO FA_RESERVE_LEDGER_GT

Line 392: INSERT INTO FA_RESERVE_LEDGER_GT

388: operation := 'Inserting into FA_RESERVE_LEDGER_GT';
389: -- run only if CRL not installed
390: If (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) then
391: if (h_reporting_flag = 'R') then
392: INSERT INTO FA_RESERVE_LEDGER_GT
393: (ASSET_ID,
394: DH_CCID,
395: DEPRN_RESERVE_ACCT,
396: DATE_PLACED_IN_SERVICE,

Line 549: INSERT INTO FA_RESERVE_LEDGER_GT

545: DH.DATE_EFFECTIVE <= ucd AND
546: nvl(DH.DATE_INEFFECTIVE, sysdate) > tod
547: ;
548: else
549: INSERT INTO FA_RESERVE_LEDGER_GT
550: (ASSET_ID,
551: DH_CCID,
552: DEPRN_RESERVE_ACCT,
553: DATE_PLACED_IN_SERVICE,

Line 710: INSERT INTO FA_RESERVE_LEDGER_GT

706: -- run only if CRL installed
707: elsif (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) then
708: -- Insert Non-Group Details
709: if (h_reporting_flag = 'R') then
710: INSERT INTO FA_RESERVE_LEDGER_GT
711: (ASSET_ID,
712: DH_CCID,
713: DEPRN_RESERVE_ACCT,
714: DATE_PLACED_IN_SERVICE,

Line 804: INSERT INTO FA_RESERVE_LEDGER_GT

800: nvl(DH.DATE_INEFFECTIVE, sysdate) > tod AND
801: -- start cua - exclude the group Assets
802: books.group_asset_id is null;
803: else
804: INSERT INTO FA_RESERVE_LEDGER_GT
805: (ASSET_ID,
806: DH_CCID,
807: DEPRN_RESERVE_ACCT,
808: DATE_PLACED_IN_SERVICE,

Line 901: INSERT INTO FA_RESERVE_LEDGER_GT

897: end if;
898: -- end cua
899: -- Insert the Group Depreciation Details
900: if (h_reporting_flag = 'R') then
901: INSERT INTO FA_RESERVE_LEDGER_GT
902: (ASSET_ID,
903: DH_CCID,
904: DEPRN_RESERVE_ACCT,
905: DATE_PLACED_IN_SERVICE,

Line 974: INSERT INTO FA_RESERVE_LEDGER_GT

970: AND GAR.DATE_EFFECTIVE <= DP.CALENDAR_PERIOD_CLOSE_DATE -- mwoodwar
971: AND nvl(GAR.DATE_INEFFECTIVE, (DP.CALENDAR_PERIOD_CLOSE_DATE + 1))
972: > DP.CALENDAR_PERIOD_CLOSE_DATE; -- mwoodwar
973: else
974: INSERT INTO FA_RESERVE_LEDGER_GT
975: (ASSET_ID,
976: DH_CCID,
977: DEPRN_RESERVE_ACCT,
978: DATE_PLACED_IN_SERVICE,

Line 1049: INSERT INTO FA_RESERVE_LEDGER_GT

1045: > DP.CALENDAR_PERIOD_CLOSE_DATE; -- mwoodwar
1046: end if;
1047: -- Insert the SuperGroup Depreciation Details MPOWELL
1048: if (h_reporting_flag = 'R') then
1049: INSERT INTO FA_RESERVE_LEDGER_GT
1050: (ASSET_ID,
1051: DH_CCID,
1052: DEPRN_RESERVE_ACCT,
1053: DATE_PLACED_IN_SERVICE,

Line 1112: INSERT INTO FA_RESERVE_LEDGER_GT

1108: AND SGR.DATE_EFFECTIVE <= DP.CALENDAR_PERIOD_CLOSE_DATE
1109: AND nvl(SGR.DATE_INEFFECTIVE, (DP.CALENDAR_PERIOD_CLOSE_DATE + 1))
1110: > DP.CALENDAR_PERIOD_CLOSE_DATE;
1111: else
1112: INSERT INTO FA_RESERVE_LEDGER_GT
1113: (ASSET_ID,
1114: DH_CCID,
1115: DEPRN_RESERVE_ACCT,
1116: DATE_PLACED_IN_SERVICE,