DBA Data[Home] [Help]

APPS.FA_RSVLDG_REP_INS_PKG dependencies on FA_DEPRN_PERIODS

Line 50: FA_DEPRN_PERIODS_MRC_V DP,

46: upc,
47: tod,
48: tpc
49: FROM
50: FA_DEPRN_PERIODS_MRC_V DP,
51: FA_DEPRN_PERIODS_MRC_V DP_FY,
52: FA_BOOK_CONTROLS_MRC_V BC
53: WHERE
54: DP.BOOK_TYPE_CODE = book AND

Line 51: FA_DEPRN_PERIODS_MRC_V DP_FY,

47: tod,
48: tpc
49: FROM
50: FA_DEPRN_PERIODS_MRC_V DP,
51: FA_DEPRN_PERIODS_MRC_V DP_FY,
52: FA_BOOK_CONTROLS_MRC_V BC
53: WHERE
54: DP.BOOK_TYPE_CODE = book AND
55: DP.PERIOD_NAME = period AND

Line 77: FA_DEPRN_PERIODS DP,

73: upc,
74: tod,
75: tpc
76: FROM
77: FA_DEPRN_PERIODS DP,
78: FA_DEPRN_PERIODS DP_FY,
79: FA_BOOK_CONTROLS BC
80: WHERE
81: DP.BOOK_TYPE_CODE = book AND

Line 78: FA_DEPRN_PERIODS DP_FY,

74: tod,
75: tpc
76: FROM
77: FA_DEPRN_PERIODS DP,
78: FA_DEPRN_PERIODS DP_FY,
79: FA_BOOK_CONTROLS BC
80: WHERE
81: DP.BOOK_TYPE_CODE = book AND
82: DP.PERIOD_NAME = period AND

Line 1009: FA_DEPRN_PERIODS_MRC_V DP

1005: FROM
1006: FA_DEPRN_SUMMARY_MRC_V DD,
1007: FA_GROUP_ASSET_RULES GAR,
1008: FA_GROUP_ASSET_DEFAULT GAD,
1009: FA_DEPRN_PERIODS_MRC_V DP
1010: WHERE
1011: DD.BOOK_TYPE_CODE = book
1012: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1013: AND GAD.SUPER_GROUP_ID is null -- MPOWELL

Line 1083: FA_DEPRN_PERIODS DP

1079: FROM
1080: FA_DEPRN_SUMMARY DD,
1081: FA_GROUP_ASSET_RULES GAR,
1082: FA_GROUP_ASSET_DEFAULT GAD,
1083: FA_DEPRN_PERIODS DP
1084: WHERE
1085: DD.BOOK_TYPE_CODE = book
1086: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1087: AND GAD.SUPER_GROUP_ID is null -- MPOWELL

Line 1148: FA_DEPRN_PERIODS_MRC_V DP

1144: FROM FA_DEPRN_SUMMARY_MRC_V DD,
1145: fa_GROUP_ASSET_RULES GAR,
1146: fa_GROUP_ASSET_DEFAULT GAD,
1147: fa_SUPER_GROUP_RULES SGR,
1148: FA_DEPRN_PERIODS_MRC_V DP
1149: WHERE DD.BOOK_TYPE_CODE = book
1150: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1151: AND GAR.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE
1152: AND GAD.SUPER_GROUP_ID = SGR.SUPER_GROUP_ID -- MPOWELL

Line 1211: FA_DEPRN_PERIODS DP

1207: FROM FA_DEPRN_SUMMARY DD,
1208: fa_GROUP_ASSET_RULES GAR,
1209: fa_GROUP_ASSET_DEFAULT GAD,
1210: fa_SUPER_GROUP_RULES SGR,
1211: FA_DEPRN_PERIODS DP
1212: WHERE DD.BOOK_TYPE_CODE = book
1213: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID
1214: AND GAR.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE
1215: AND GAD.SUPER_GROUP_ID = SGR.SUPER_GROUP_ID -- MPOWELL