DBA Data[Home] [Help]

APPS.FA_FASNBV_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 58: FA_DEPRN_PERIODS

54: ,'DD-MM-YYYY HH24:MI:SS'),
55: FISCAL_YEAR
56: INTO L_PERIOD_NAME,L_PERIOD_PC,L_PERIOD_POD,L_PERIOD_PCD,L_PERIOD_FY
57: FROM
58: FA_DEPRN_PERIODS
59: WHERE BOOK_TYPE_CODE = P_BOOK
60: AND PERIOD_NAME = P_PERIOD1;
61: PERIOD1_PC := L_PERIOD_PC;
62: PERIOD1_POD := L_PERIOD_POD;

Line 129: FA_DEPRN_PERIODS DP

125: SELECT
126: DP.PERIOD_COUNTER
127: INTO L_OPEN_PC
128: FROM
129: FA_DEPRN_PERIODS DP
130: WHERE DP.BOOK_TYPE_CODE = P_BOOK
131: AND DP.PERIOD_COUNTER = (
132: SELECT
133: MAX(DPZ.PERIOD_COUNTER)

Line 136: FA_DEPRN_PERIODS DPZ,

132: SELECT
133: MAX(DPZ.PERIOD_COUNTER)
134: FROM
135: FA_DEPRN_SUMMARY DSZ,
136: FA_DEPRN_PERIODS DPZ,
137: FA_BOOKS BK
138: WHERE DPZ.BOOK_TYPE_CODE = P_BOOK
139: AND DPZ.FISCAL_YEAR < PERIOD1_FY
140: AND DSZ.BOOK_TYPE_CODE = P_BOOK