DBA Data[Home] [Help]

APPS.JL_JLMXFIMP_XMLP_PKG dependencies on FA_FISCAL_YEAR

Line 381: FA_FISCAL_YEAR FY,

377: CP.END_DATE
378: INTO V_START_DATE_FISCAL_YEAR,V_END_DATE_FISCAL_YEAR,V_START_DATE,V_END_DATE
379: FROM
380: FA_BOOK_CONTROLS_MRC_V BC,
381: FA_FISCAL_YEAR FY,
382: FA_CALENDAR_PERIODS CP
383: WHERE FY.FISCAL_YEAR = P_CURR_FY
384: AND BC.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
385: AND BC.FISCAL_YEAR_NAME = FY.FISCAL_YEAR_NAME

Line 407: FA_FISCAL_YEAR FY,

403: CP.END_DATE
404: INTO V_START_DATE_FISCAL_YEAR,V_END_DATE_FISCAL_YEAR,V_START_DATE,V_END_DATE
405: FROM
406: FA_BOOK_CONTROLS BC,
407: FA_FISCAL_YEAR FY,
408: FA_CALENDAR_PERIODS CP
409: WHERE FY.FISCAL_YEAR = P_CURR_FY
410: AND BC.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
411: AND BC.FISCAL_YEAR_NAME = FY.FISCAL_YEAR_NAME