APPS.FA_FAS400_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 84: FROM FA_DEPRN_PERIODS_MRC_V

80: l_period_POD,
81: l_period_PCD,
82: l_period_closed,
83: l_period_FY
84: FROM FA_DEPRN_PERIODS_MRC_V
85: WHERE book_type_code = P_BOOK
86: AND period_name = P_PERIOD1;
87: ELSE
88: SELECT period_name,

Line 100: FROM FA_DEPRN_PERIODS

96: l_period_POD,
97: l_period_PCD,
98: l_period_closed,
99: l_period_FY
100: FROM FA_DEPRN_PERIODS
101: WHERE book_type_code = P_BOOK
102: AND period_name = P_PERIOD1;
103: END IF;
104: Period1_PC := l_period_PC;

Line 370: FA_DEPRN_PERIODS_MRC_V DP,

366: upc,
367: tod,
368: tpc
369: FROM
370: FA_DEPRN_PERIODS_MRC_V DP,
371: FA_DEPRN_PERIODS_MRC_V DP_FY,
372: FA_BOOK_CONTROLS_MRC_V BC
373: WHERE
374: DP.BOOK_TYPE_CODE = book AND

Line 371: FA_DEPRN_PERIODS_MRC_V DP_FY,

367: tod,
368: tpc
369: FROM
370: FA_DEPRN_PERIODS_MRC_V DP,
371: FA_DEPRN_PERIODS_MRC_V DP_FY,
372: FA_BOOK_CONTROLS_MRC_V BC
373: WHERE
374: DP.BOOK_TYPE_CODE = book AND
375: DP.PERIOD_NAME = period AND

Line 397: FA_DEPRN_PERIODS DP,

393: upc,
394: tod,
395: tpc
396: FROM
397: FA_DEPRN_PERIODS DP,
398: FA_DEPRN_PERIODS DP_FY,
399: FA_BOOK_CONTROLS BC
400: WHERE
401: DP.BOOK_TYPE_CODE = book AND

Line 398: FA_DEPRN_PERIODS DP_FY,

394: tod,
395: tpc
396: FROM
397: FA_DEPRN_PERIODS DP,
398: FA_DEPRN_PERIODS DP_FY,
399: FA_BOOK_CONTROLS BC
400: WHERE
401: DP.BOOK_TYPE_CODE = book AND
402: DP.PERIOD_NAME = period AND

Line 976: FA_DEPRN_PERIODS_MRC_V DP

972: FROM
973: FA_DEPRN_SUMMARY_MRC_V DD,
974: FA_GROUP_ASSET_RULES GAR,
975: FA_GROUP_ASSET_DEFAULT GAD,
976: FA_DEPRN_PERIODS_MRC_V DP
977: WHERE
978: DD.BOOK_TYPE_CODE = book
979: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
980: AND GAD.SUPER_GROUP_ID is null -- MPOWELL

Line 1049: FA_DEPRN_PERIODS DP

1045: FROM
1046: FA_DEPRN_SUMMARY DD,
1047: FA_GROUP_ASSET_RULES GAR,
1048: FA_GROUP_ASSET_DEFAULT GAD,
1049: FA_DEPRN_PERIODS DP
1050: WHERE
1051: DD.BOOK_TYPE_CODE = book
1052: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1053: AND GAD.SUPER_GROUP_ID is null -- MPOWELL

Line 1112: FA_DEPRN_PERIODS_MRC_V DP

1108: FROM FA_DEPRN_SUMMARY_MRC_V DD,
1109: fa_GROUP_ASSET_RULES GAR,
1110: fa_GROUP_ASSET_DEFAULT GAD,
1111: fa_SUPER_GROUP_RULES SGR,
1112: FA_DEPRN_PERIODS_MRC_V 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

Line 1175: FA_DEPRN_PERIODS DP

1171: FROM FA_DEPRN_SUMMARY DD,
1172: fa_GROUP_ASSET_RULES GAR,
1173: fa_GROUP_ASSET_DEFAULT GAD,
1174: fa_SUPER_GROUP_RULES SGR,
1175: FA_DEPRN_PERIODS DP
1176: WHERE DD.BOOK_TYPE_CODE = book
1177: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1178: AND GAR.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE
1179: AND GAD.SUPER_GROUP_ID = SGR.SUPER_GROUP_ID -- MPOWELL