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.FA_RSVLDG_REP_INS_PKG dependencies on FA_RESERVE_LEDGER_GT

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

109: WHEN NO_DATA_FOUND THEN
110: bonus_count := 0;
111: END;
112: -- end bugfix 6677528
113: operation := 'Inserting into FA_RESERVE_LEDGER_GT';
114:
115: -- run only if CRL not installed
116:
117: If (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) then

Line 123: INSERT INTO FA_RESERVE_LEDGER_GT

119: If bonus_count > 0 then
120:
121: if (h_reporting_flag = 'R') then
122:
123: INSERT INTO FA_RESERVE_LEDGER_GT
124: (ASSET_ID,
125: DH_CCID,
126: DEPRN_RESERVE_ACCT,
127: DATE_PLACED_IN_SERVICE,

Line 310: INSERT INTO FA_RESERVE_LEDGER_GT

306: else
307: /* ie h_reporting_flag <> 'R' */
308:
309: -- start here...
310: INSERT INTO FA_RESERVE_LEDGER_GT
311: (ASSET_ID,
312: DH_CCID,
313: DEPRN_RESERVE_ACCT,
314: DATE_PLACED_IN_SERVICE,

Line 503: INSERT INTO FA_RESERVE_LEDGER_GT

499:
500: -- run only if CRL not installed
501: if (h_reporting_flag = 'R') then
502:
503: INSERT INTO FA_RESERVE_LEDGER_GT
504: (ASSET_ID,
505: DH_CCID,
506: DEPRN_RESERVE_ACCT,
507: DATE_PLACED_IN_SERVICE,

Line 611: INSERT INTO FA_RESERVE_LEDGER_GT

607: Else -- reporting vs primary
608:
609: /* ie. h_reporting_flag <> 'R' */
610:
611: INSERT INTO FA_RESERVE_LEDGER_GT
612: (ASSET_ID,
613: DH_CCID,
614: DEPRN_RESERVE_ACCT,
615: DATE_PLACED_IN_SERVICE,

Line 724: INSERT INTO FA_RESERVE_LEDGER_GT

720: elsif (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) then
721:
722: -- Insert Non-Group Details
723: if (h_reporting_flag = 'R') then
724: INSERT INTO FA_RESERVE_LEDGER_GT
725: (ASSET_ID,
726: DH_CCID,
727: DEPRN_RESERVE_ACCT,
728: DATE_PLACED_IN_SERVICE,

Line 837: INSERT INTO FA_RESERVE_LEDGER_GT

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

Line 956: INSERT INTO FA_RESERVE_LEDGER_GT

952:
953: -- Insert the Group Depreciation Details
954:
955: if (h_reporting_flag = 'R') then
956: INSERT INTO FA_RESERVE_LEDGER_GT
957: (ASSET_ID,
958: DH_CCID,
959: DEPRN_RESERVE_ACCT,
960: DATE_PLACED_IN_SERVICE,

Line 1030: INSERT INTO FA_RESERVE_LEDGER_GT

1026: AND GAR.DATE_EFFECTIVE <= DP.CALENDAR_PERIOD_CLOSE_DATE -- mwoodwar
1027: AND nvl(GAR.DATE_INEFFECTIVE, (DP.CALENDAR_PERIOD_CLOSE_DATE + 1))
1028: > DP.CALENDAR_PERIOD_CLOSE_DATE; -- mwoodwar
1029: else
1030: INSERT INTO FA_RESERVE_LEDGER_GT
1031: (ASSET_ID,
1032: DH_CCID,
1033: DEPRN_RESERVE_ACCT,
1034: DATE_PLACED_IN_SERVICE,

Line 1108: INSERT INTO FA_RESERVE_LEDGER_GT

1104:
1105: -- Insert the SuperGroup Depreciation Details MPOWELL
1106:
1107: if (h_reporting_flag = 'R') then
1108: INSERT INTO FA_RESERVE_LEDGER_GT
1109: (ASSET_ID,
1110: DH_CCID,
1111: DEPRN_RESERVE_ACCT,
1112: DATE_PLACED_IN_SERVICE,

Line 1171: INSERT INTO FA_RESERVE_LEDGER_GT

1167: AND SGR.DATE_EFFECTIVE <= DP.CALENDAR_PERIOD_CLOSE_DATE
1168: AND nvl(SGR.DATE_INEFFECTIVE, (DP.CALENDAR_PERIOD_CLOSE_DATE + 1))
1169: > DP.CALENDAR_PERIOD_CLOSE_DATE;
1170: else
1171: INSERT INTO FA_RESERVE_LEDGER_GT
1172: (ASSET_ID,
1173: DH_CCID,
1174: DEPRN_RESERVE_ACCT,
1175: DATE_PLACED_IN_SERVICE,