APPS.FA_MC_UPG1_PKG dependencies on FA_DEPRN_SUMMARY

Line 1053: fa_deprn_summary ds,

1049: NULL)),
1050: 'F',
1051: ds.period_counter
1052: FROM
1053: fa_deprn_summary ds,
1054: fa_mc_conversion_rates cr,
1055: fa_books bk,
1056: fa_additions ad
1057: WHERE

Line 1071: FROM fa_deprn_summary ds2

1067: ds.asset_id = bk.asset_id AND
1068: ds.book_type_code = bk.book_type_code AND
1069: ds.period_counter = (
1070: SELECT max(ds2.period_counter)
1071: FROM fa_deprn_summary ds2
1072: WHERE ds2.asset_id = ds.asset_id AND
1073: ds2.book_type_code =
1074: ds.book_type_code AND
1075: ds2.period_counter between p_start_pc

Line 1124: fa_deprn_summary ds,

1120: 'L',
1121: ds.period_counter
1122: FROM
1123: fa_books bk,
1124: fa_deprn_summary ds,
1125: fa_additions ad,
1126: fa_mc_conversion_rates cr
1127: WHERE
1128: bk.date_ineffective is NULL AND

Line 1141: FROM fa_deprn_summary ds2

1137: ds.asset_id = bk.asset_id AND
1138: ds.book_type_code = bk.book_type_code AND
1139: ds.period_counter = (
1140: SELECT max(ds2.period_counter)
1141: FROM fa_deprn_summary ds2
1142: WHERE ds2.asset_id = ds.asset_id AND
1143: ds2.book_type_code =
1144: ds.book_type_code) AND
1145: rownum+0 <= G_Max_Commit_Size;