APPS.FA_FAS403_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 62: FROM FA_DEPRN_PERIODS

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

Line 347: FA_DEPRN_PERIODS_MRC_V DP,

343: upc,
344: tod,
345: tpc
346: FROM
347: FA_DEPRN_PERIODS_MRC_V DP,
348: FA_DEPRN_PERIODS_MRC_V DP_FY,
349: FA_BOOK_CONTROLS_MRC_V BC
350: WHERE
351: DP.BOOK_TYPE_CODE = book AND

Line 348: FA_DEPRN_PERIODS_MRC_V DP_FY,

344: tod,
345: tpc
346: FROM
347: FA_DEPRN_PERIODS_MRC_V DP,
348: FA_DEPRN_PERIODS_MRC_V DP_FY,
349: FA_BOOK_CONTROLS_MRC_V BC
350: WHERE
351: DP.BOOK_TYPE_CODE = book AND
352: DP.PERIOD_NAME = period AND

Line 374: FA_DEPRN_PERIODS DP,

370: upc,
371: tod,
372: tpc
373: FROM
374: FA_DEPRN_PERIODS DP,
375: FA_DEPRN_PERIODS DP_FY,
376: FA_BOOK_CONTROLS BC
377: WHERE
378: DP.BOOK_TYPE_CODE = book AND

Line 375: FA_DEPRN_PERIODS DP_FY,

371: tod,
372: tpc
373: FROM
374: FA_DEPRN_PERIODS DP,
375: FA_DEPRN_PERIODS DP_FY,
376: FA_BOOK_CONTROLS BC
377: WHERE
378: DP.BOOK_TYPE_CODE = book AND
379: DP.PERIOD_NAME = period AND

Line 953: FA_DEPRN_PERIODS_MRC_V DP

949: FROM
950: FA_DEPRN_SUMMARY_MRC_V DD,
951: FA_GROUP_ASSET_RULES GAR,
952: FA_GROUP_ASSET_DEFAULT GAD,
953: FA_DEPRN_PERIODS_MRC_V DP
954: WHERE
955: DD.BOOK_TYPE_CODE = book
956: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
957: AND GAD.SUPER_GROUP_ID is null -- MPOWELL

Line 1026: FA_DEPRN_PERIODS DP

1022: FROM
1023: FA_DEPRN_SUMMARY DD,
1024: FA_GROUP_ASSET_RULES GAR,
1025: FA_GROUP_ASSET_DEFAULT GAD,
1026: FA_DEPRN_PERIODS DP
1027: WHERE
1028: DD.BOOK_TYPE_CODE = book
1029: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1030: AND GAD.SUPER_GROUP_ID is null -- MPOWELL

Line 1089: FA_DEPRN_PERIODS_MRC_V DP

1085: FROM FA_DEPRN_SUMMARY_MRC_V DD,
1086: fa_GROUP_ASSET_RULES GAR,
1087: fa_GROUP_ASSET_DEFAULT GAD,
1088: fa_SUPER_GROUP_RULES SGR,
1089: FA_DEPRN_PERIODS_MRC_V DP
1090: WHERE DD.BOOK_TYPE_CODE = book
1091: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1092: AND GAR.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE
1093: AND GAD.SUPER_GROUP_ID = SGR.SUPER_GROUP_ID -- MPOWELL

Line 1152: FA_DEPRN_PERIODS DP

1148: FROM FA_DEPRN_SUMMARY DD,
1149: fa_GROUP_ASSET_RULES GAR,
1150: fa_GROUP_ASSET_DEFAULT GAD,
1151: fa_SUPER_GROUP_RULES SGR,
1152: FA_DEPRN_PERIODS DP
1153: WHERE DD.BOOK_TYPE_CODE = book
1154: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1155: AND GAR.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE
1156: AND GAD.SUPER_GROUP_ID = SGR.SUPER_GROUP_ID -- MPOWELL