DBA Data[Home] [Help]

APPS.FA_FASCAPSP_XMLP_PKG dependencies on FA_BOOK_CONTROLS

Line 74: FA_BOOK_CONTROLS BC_TAX

70: INTO
71: L_FISCAL_YEAR,
72: L_END_DATE
73: FROM FA_FISCAL_YEAR FY_TAX,
74: FA_BOOK_CONTROLS BC_TAX
75: WHERE BC_TAX.BOOK_TYPE_CODE = P_TAX_BOOK AND
76: BC_TAX.FISCAL_YEAR_NAME = FY_TAX.FISCAL_YEAR_NAME
77: AND P_DPIS BETWEEN FY_TAX.START_DATE AND FY_TAX.END_DATE;
78:

Line 85: FA_BOOK_CONTROLS BC_BUD

81: INTO
82: L_PERIOD_NUM
83: FROM FA_DEPRN_PERIODS DP_BUD,
84: FA_FISCAL_YEAR FY_BUD,
85: FA_BOOK_CONTROLS BC_BUD
86: WHERE BC_BUD.BOOK_TYPE_CODE = P_BUDGET_BOOK AND
87: P_DPIS BETWEEN FY_BUD.START_DATE AND FY_BUD.END_DATE
88: AND FY_BUD.FISCAL_YEAR_NAME = BC_BUD.FISCAL_YEAR_NAME
89: AND DP_BUD.BOOK_TYPE_CODE = P_BUDGET_BOOK AND