APPS.FA_RSVLDG_REP_INS_PKG dependencies on FA_RESERVE_LEDGER_GT

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

113: WHEN NO_DATA_FOUND THEN
114: bonus_count := 0;
115: END;
116: -- end bugfix 6677528
117: operation := 'Inserting into FA_RESERVE_LEDGER_GT';
118:
119: --==================================================
120: --OPEN LOAD WORKER CURSOR HERE.
121: --==================================================

Line 147: INSERT INTO FA_RESERVE_LEDGER_GT

143:
144: If bonus_count > 0 then
145:
146: if (h_reporting_flag = 'R') then
147: INSERT INTO FA_RESERVE_LEDGER_GT
148: (
149: ASSET_ID ,
150: DH_CCID ,
151: DEPRN_RESERVE_ACCT ,

Line 323: INSERT INTO FA_RESERVE_LEDGER_GT

319: else
320: /* ie h_reporting_flag <> 'R' */
321:
322: -- start here...
323: INSERT INTO FA_RESERVE_LEDGER_GT
324: (
325: ASSET_ID ,
326: DH_CCID ,
327: DEPRN_RESERVE_ACCT ,

Line 502: INSERT INTO FA_RESERVE_LEDGER_GT

498: /* ie. bonus_count = 0 */
499:
500: -- run only if CRL not installed
501: if (h_reporting_flag = 'R') then
502: INSERT INTO FA_RESERVE_LEDGER_GT
503: ( ASSET_ID ,
504: DH_CCID ,
505: DEPRN_RESERVE_ACCT ,
506: DATE_PLACED_IN_SERVICE,

Line 600: INSERT INTO FA_RESERVE_LEDGER_GT

596: AND DH.DATE_EFFECTIVE <= ucd
597: AND NVL(DH.DATE_INEFFECTIVE, sysdate) > tod;
598: Else -- reporting vs primary
599: /* ie. h_reporting_flag <> 'R' */
600: INSERT INTO FA_RESERVE_LEDGER_GT
601: (
602: ASSET_ID ,
603: DH_CCID ,
604: DEPRN_RESERVE_ACCT ,

Line 711: INSERT INTO FA_RESERVE_LEDGER_GT

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

Line 814: INSERT INTO FA_RESERVE_LEDGER_GT

810: AND DH.DATE_EFFECTIVE <= ucd
811: AND NVL(DH.DATE_INEFFECTIVE, sysdate) > tod -- start cua - exclude the group Assets
812: AND books.group_asset_id IS NULL;
813: else
814: INSERT INTO FA_RESERVE_LEDGER_GT
815: (
816: ASSET_ID ,
817: DH_CCID ,
818: DEPRN_RESERVE_ACCT ,

Line 923: INSERT INTO FA_RESERVE_LEDGER_GT

919:
920:
921: -- Insert the Group Depreciation Details
922: IF (h_reporting_flag = 'R') THEN
923: INSERT INTO FA_RESERVE_LEDGER_GT
924: ( ASSET_ID ,
925: DH_CCID ,
926: DEPRN_RESERVE_ACCT ,
927: DATE_PLACED_IN_SERVICE,

Line 1008: INSERT INTO FA_RESERVE_LEDGER_GT

1004: NVL(BR.END_YEAR, DP.FISCAL_YEAR))
1005: AND GAR.DATE_EFFECTIVE <= DP.CALENDAR_PERIOD_CLOSE_DATE -- mwoodwar
1006: AND NVL(GAR.DATE_INEFFECTIVE, (DP.CALENDAR_PERIOD_CLOSE_DATE + 1)) > DP.CALENDAR_PERIOD_CLOSE_DATE; -- mwoodwar
1007: ELSE
1008: INSERT INTO FA_RESERVE_LEDGER_GT
1009: ( ASSET_ID ,
1010: DH_CCID ,
1011: DEPRN_RESERVE_ACCT ,
1012: DATE_PLACED_IN_SERVICE,

Line 1098: INSERT INTO FA_RESERVE_LEDGER_GT

1094:
1095: -- Insert the SuperGroup Depreciation Details MPOWELL
1096:
1097: IF (h_reporting_flag = 'R') THEN
1098: INSERT INTO FA_RESERVE_LEDGER_GT
1099: (
1100: ASSET_ID ,
1101: DH_CCID ,
1102: DEPRN_RESERVE_ACCT ,

Line 1176: INSERT INTO FA_RESERVE_LEDGER_GT

1172: AND NVL(GAR.DATE_INEFFECTIVE, (DP.CALENDAR_PERIOD_CLOSE_DATE + 1)) > DP.CALENDAR_PERIOD_CLOSE_DATE
1173: AND SGR.DATE_EFFECTIVE <= DP.CALENDAR_PERIOD_CLOSE_DATE
1174: AND NVL(SGR.DATE_INEFFECTIVE, (DP.CALENDAR_PERIOD_CLOSE_DATE + 1)) > DP.CALENDAR_PERIOD_CLOSE_DATE;
1175: ELSE
1176: INSERT INTO FA_RESERVE_LEDGER_GT
1177: (
1178: ASSET_ID ,
1179: DH_CCID ,
1180: DEPRN_RESERVE_ACCT ,