APPS.FA_FAS480_XMLP_PKG dependencies on FA_DEPRN_PERIODS_MRC_V

Line 124: FROM FA_DEPRN_PERIODS_MRC_V

120: l_period_POD,
121: l_period_PCD,
122: l_period_closed,
123: l_period_FY
124: FROM FA_DEPRN_PERIODS_MRC_V
125: WHERE book_type_code = P_BOOK
126: AND period_name = P_PERIOD1;
127: ELSE
128: SELECT period_counter,

Line 383: FA_DEPRN_PERIODS_MRC_V DP,

379: upc,
380: tod,
381: tpc
382: FROM
383: FA_DEPRN_PERIODS_MRC_V DP,
384: FA_DEPRN_PERIODS_MRC_V DP_FY,
385: FA_BOOK_CONTROLS_MRC_V BC
386: WHERE
387: DP.BOOK_TYPE_CODE = book AND

Line 384: FA_DEPRN_PERIODS_MRC_V DP_FY,

380: tod,
381: tpc
382: FROM
383: FA_DEPRN_PERIODS_MRC_V DP,
384: FA_DEPRN_PERIODS_MRC_V DP_FY,
385: FA_BOOK_CONTROLS_MRC_V BC
386: WHERE
387: DP.BOOK_TYPE_CODE = book AND
388: DP.PERIOD_NAME = period AND

Line 989: FA_DEPRN_PERIODS_MRC_V DP

985: FROM
986: FA_DEPRN_SUMMARY_MRC_V DD,
987: FA_GROUP_ASSET_RULES GAR,
988: FA_GROUP_ASSET_DEFAULT GAD,
989: FA_DEPRN_PERIODS_MRC_V DP
990: WHERE
991: DD.BOOK_TYPE_CODE = book
992: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
993: AND GAD.SUPER_GROUP_ID is null -- MPOWELL

Line 1125: FA_DEPRN_PERIODS_MRC_V DP

1121: FROM FA_DEPRN_SUMMARY_MRC_V DD,
1122: fa_GROUP_ASSET_RULES GAR,
1123: fa_GROUP_ASSET_DEFAULT GAD,
1124: fa_SUPER_GROUP_RULES SGR,
1125: FA_DEPRN_PERIODS_MRC_V DP
1126: WHERE DD.BOOK_TYPE_CODE = book
1127: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1128: AND GAR.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE
1129: AND GAD.SUPER_GROUP_ID = SGR.SUPER_GROUP_ID -- MPOWELL