APPS.JE_JEFIASDR_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 72: FA_DEPRN_PERIODS F,

68: ,C.LAST_DEPRN_RUN_DATE),
69: T.PERIOD_CLOSE_DATE TIME_TO_CLOSE_DATE
70: INTO C_FROM_OPEN_DATE,C_FROM_CLOSE_DATE,C_REPORT_DATE,C_FROM_COUNTER,C_CALENDAR_OPEN_DATE,C_CALENDAR_CLOSE_DATE,C_FROM_FISCAL_YEAR,C_TO_COUNTER,C_TO_OPEN_DATE,C_TO_CLOSE_DATE,C_TIME_TO_CLOSE_DATE
71: FROM
72: FA_DEPRN_PERIODS F,
73: FA_DEPRN_PERIODS T,
74: FA_BOOK_CONTROLS C
75: WHERE F.PERIOD_COUNTER = (
76: SELECT

Line 73: FA_DEPRN_PERIODS T,

69: T.PERIOD_CLOSE_DATE TIME_TO_CLOSE_DATE
70: INTO C_FROM_OPEN_DATE,C_FROM_CLOSE_DATE,C_REPORT_DATE,C_FROM_COUNTER,C_CALENDAR_OPEN_DATE,C_CALENDAR_CLOSE_DATE,C_FROM_FISCAL_YEAR,C_TO_COUNTER,C_TO_OPEN_DATE,C_TO_CLOSE_DATE,C_TIME_TO_CLOSE_DATE
71: FROM
72: FA_DEPRN_PERIODS F,
73: FA_DEPRN_PERIODS T,
74: FA_BOOK_CONTROLS C
75: WHERE F.PERIOD_COUNTER = (
76: SELECT
77: MIN(F1.PERIOD_COUNTER)

Line 79: FA_DEPRN_PERIODS F1

75: WHERE F.PERIOD_COUNTER = (
76: SELECT
77: MIN(F1.PERIOD_COUNTER)
78: FROM
79: FA_DEPRN_PERIODS F1
80: WHERE F1.BOOK_TYPE_CODE = P_TAX_BOOK
81: AND F1.FISCAL_YEAR = F.FISCAL_YEAR )
82: AND T.PERIOD_NAME = P_PERIOD_NAME
83: AND F.BOOK_TYPE_CODE = P_TAX_BOOK

Line 134: FA_DEPRN_PERIODS P,

130: SELECT
131: MIN(L.PERIOD_COUNTER)
132: INTO CP_LASTYR_BEGIN_PERIOD_COUNTER
133: FROM
134: FA_DEPRN_PERIODS P,
135: FA_DEPRN_PERIODS L
136: WHERE P.BOOK_TYPE_CODE = P_TAX_BOOK
137: AND L.BOOK_TYPE_CODE = P_TAX_BOOK
138: AND P.PERIOD_NAME = P_PERIOD_NAME

Line 135: FA_DEPRN_PERIODS L

131: MIN(L.PERIOD_COUNTER)
132: INTO CP_LASTYR_BEGIN_PERIOD_COUNTER
133: FROM
134: FA_DEPRN_PERIODS P,
135: FA_DEPRN_PERIODS L
136: WHERE P.BOOK_TYPE_CODE = P_TAX_BOOK
137: AND L.BOOK_TYPE_CODE = P_TAX_BOOK
138: AND P.PERIOD_NAME = P_PERIOD_NAME
139: AND L.FISCAL_YEAR = P.FISCAL_YEAR - 1;

Line 150: FA_DEPRN_PERIODS

146: MIN(PERIOD_COUNTER) CORPORATE_FROM_COUNTER,
147: MIN(CALENDAR_PERIOD_OPEN_DATE) CORPORATE_CALENDAR_OPEN_DATE
148: INTO C_CORP_FROM_COUNTER,C_CORP_CALENDAR_OPEN_DATE
149: FROM
150: FA_DEPRN_PERIODS
151: WHERE BOOK_TYPE_CODE = C_DISTRIBUTION_SOURCE_BOOK
152: AND FISCAL_YEAR = C_FROM_FISCAL_YEAR;
153: IF P_DEBUG_SWITCH = 'Y' THEN
154: /*SRW.MESSAGE(004

Line 176: FA_DEPRN_PERIODS

172: NVL(MAX(CALENDAR_PERIOD_CLOSE_DATE)
173: ,SYSDATE) CORPORATE_CALENDAR_CLOSE_DATE
174: INTO C_CORP_TO_COUNTER,C_CORP_CALENDAR_CLOSE_DATE
175: FROM
176: FA_DEPRN_PERIODS
177: WHERE BOOK_TYPE_CODE = C_DISTRIBUTION_SOURCE_BOOK
178: AND C_CALENDAR_CLOSE_DATE between CALENDAR_PERIOD_OPEN_DATE
179: AND CALENDAR_PERIOD_CLOSE_DATE
180: AND FISCAL_YEAR = C_FROM_FISCAL_YEAR;

Line 205: FA_DEPRN_PERIODS T,

201: ,C.LAST_DEPRN_RUN_DATE),
202: T.PERIOD_CLOSE_DATE CORP_TIME_TO_CLOSE_DATE
203: INTO C_CORP_TO_OPEN_DATE,C_CORP_TO_CLOSE_DATE,C_CORP_TIME_TO_CLOSE_DATE
204: FROM
205: FA_DEPRN_PERIODS T,
206: FA_BOOK_CONTROLS C
207: WHERE T.PERIOD_COUNTER = C_CORP_TO_COUNTER
208: AND T.BOOK_TYPE_CODE = C_DISTRIBUTION_SOURCE_BOOK
209: AND T.FISCAL_YEAR = C_FROM_FISCAL_YEAR

Line 255: FA_DEPRN_PERIODS

251: SELECT
252: PERIOD_CLOSE_DATE
253: INTO CP_CLOSE_DATE
254: FROM
255: FA_DEPRN_PERIODS
256: WHERE BOOK_TYPE_CODE = P_TAX_BOOK
257: AND PERIOD_COUNTER = C_TO_COUNTER;
258: IF P_DEBUG_SWITCH = 'Y' THEN
259: /*SRW.MESSAGE(009