APPS.FA_FAS480_XMLP_PKG dependencies on FA_DEPRN_PERIODS

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 138: FROM FA_DEPRN_PERIODS

134: l_period_POD,
135: l_period_PCD,
136: l_period_closed,
137: l_period_FY
138: FROM FA_DEPRN_PERIODS
139: WHERE book_type_code = P_BOOK
140: AND period_name = P_PERIOD1;
141: END IF;
142: Period1_POD := l_period_POD;

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 410: FA_DEPRN_PERIODS DP,

406: upc,
407: tod,
408: tpc
409: FROM
410: FA_DEPRN_PERIODS DP,
411: FA_DEPRN_PERIODS DP_FY,
412: FA_BOOK_CONTROLS BC
413: WHERE
414: DP.BOOK_TYPE_CODE = book AND

Line 411: FA_DEPRN_PERIODS DP_FY,

407: tod,
408: tpc
409: FROM
410: FA_DEPRN_PERIODS DP,
411: FA_DEPRN_PERIODS DP_FY,
412: FA_BOOK_CONTROLS BC
413: WHERE
414: DP.BOOK_TYPE_CODE = book AND
415: 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 1062: FA_DEPRN_PERIODS DP

1058: FROM
1059: FA_DEPRN_SUMMARY DD,
1060: FA_GROUP_ASSET_RULES GAR,
1061: FA_GROUP_ASSET_DEFAULT GAD,
1062: FA_DEPRN_PERIODS DP
1063: WHERE
1064: DD.BOOK_TYPE_CODE = book
1065: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1066: 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

Line 1188: FA_DEPRN_PERIODS DP

1184: FROM FA_DEPRN_SUMMARY DD,
1185: fa_GROUP_ASSET_RULES GAR,
1186: fa_GROUP_ASSET_DEFAULT GAD,
1187: fa_SUPER_GROUP_RULES SGR,
1188: FA_DEPRN_PERIODS DP
1189: WHERE DD.BOOK_TYPE_CODE = book
1190: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1191: AND GAR.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE
1192: AND GAD.SUPER_GROUP_ID = SGR.SUPER_GROUP_ID -- MPOWELL