APPS.FA_FAS401_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 60: FROM FA_DEPRN_PERIODS

56: l_period_POD,
57: l_period_PCD,
58: l_period_closed,
59: l_period_FY
60: FROM FA_DEPRN_PERIODS
61: WHERE book_type_code = P_BOOK
62: AND period_name = P_PERIOD1;
63: Period1_PC := l_period_PC;
64: Period1_POD := l_period_POD;

Line 307: FA_DEPRN_PERIODS_MRC_V DP,

303: upc,
304: tod,
305: tpc
306: FROM
307: FA_DEPRN_PERIODS_MRC_V DP,
308: FA_DEPRN_PERIODS_MRC_V DP_FY,
309: FA_BOOK_CONTROLS_MRC_V BC
310: WHERE
311: DP.BOOK_TYPE_CODE = book AND

Line 308: FA_DEPRN_PERIODS_MRC_V DP_FY,

304: tod,
305: tpc
306: FROM
307: FA_DEPRN_PERIODS_MRC_V DP,
308: FA_DEPRN_PERIODS_MRC_V DP_FY,
309: FA_BOOK_CONTROLS_MRC_V BC
310: WHERE
311: DP.BOOK_TYPE_CODE = book AND
312: DP.PERIOD_NAME = period AND

Line 334: FA_DEPRN_PERIODS DP,

330: upc,
331: tod,
332: tpc
333: FROM
334: FA_DEPRN_PERIODS DP,
335: FA_DEPRN_PERIODS DP_FY,
336: FA_BOOK_CONTROLS BC
337: WHERE
338: DP.BOOK_TYPE_CODE = book AND

Line 335: FA_DEPRN_PERIODS DP_FY,

331: tod,
332: tpc
333: FROM
334: FA_DEPRN_PERIODS DP,
335: FA_DEPRN_PERIODS DP_FY,
336: FA_BOOK_CONTROLS BC
337: WHERE
338: DP.BOOK_TYPE_CODE = book AND
339: DP.PERIOD_NAME = period AND

Line 913: FA_DEPRN_PERIODS_MRC_V DP

909: FROM
910: FA_DEPRN_SUMMARY_MRC_V DD,
911: FA_GROUP_ASSET_RULES GAR,
912: FA_GROUP_ASSET_DEFAULT GAD,
913: FA_DEPRN_PERIODS_MRC_V DP
914: WHERE
915: DD.BOOK_TYPE_CODE = book
916: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
917: AND GAD.SUPER_GROUP_ID is null -- MPOWELL

Line 986: FA_DEPRN_PERIODS DP

982: FROM
983: FA_DEPRN_SUMMARY DD,
984: FA_GROUP_ASSET_RULES GAR,
985: FA_GROUP_ASSET_DEFAULT GAD,
986: FA_DEPRN_PERIODS DP
987: WHERE
988: DD.BOOK_TYPE_CODE = book
989: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
990: AND GAD.SUPER_GROUP_ID is null -- MPOWELL

Line 1049: FA_DEPRN_PERIODS_MRC_V DP

1045: FROM FA_DEPRN_SUMMARY_MRC_V DD,
1046: fa_GROUP_ASSET_RULES GAR,
1047: fa_GROUP_ASSET_DEFAULT GAD,
1048: fa_SUPER_GROUP_RULES SGR,
1049: FA_DEPRN_PERIODS_MRC_V DP
1050: WHERE DD.BOOK_TYPE_CODE = book
1051: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1052: AND GAR.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE
1053: AND GAD.SUPER_GROUP_ID = SGR.SUPER_GROUP_ID -- MPOWELL

Line 1112: FA_DEPRN_PERIODS DP

1108: FROM FA_DEPRN_SUMMARY DD,
1109: fa_GROUP_ASSET_RULES GAR,
1110: fa_GROUP_ASSET_DEFAULT GAD,
1111: fa_SUPER_GROUP_RULES SGR,
1112: FA_DEPRN_PERIODS DP
1113: WHERE DD.BOOK_TYPE_CODE = book
1114: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1115: AND GAR.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE
1116: AND GAD.SUPER_GROUP_ID = SGR.SUPER_GROUP_ID -- MPOWELL