DBA Data[Home] [Help]

APPS.INV_INVARUIR_XMLP_PKG dependencies on BOM_CAL_YEAR_START_DATES

Line 98: BOM_CAL_YEAR_START_DATES BY1,

94: TO_CHAR(MIN(BY2.YEAR_START_DATE) - 1
95: ,'DD-MON-RRRR')
96: INTO YEARBEGINDATE,YEARENDDATE
97: FROM
98: BOM_CAL_YEAR_START_DATES BY1,
99: BOM_CAL_YEAR_START_DATES BY2
100: WHERE BY1.CALENDAR_CODE = S_CALENDARCODE
101: AND BY1.EXCEPTION_SET_ID = S_CALENDAREXCEPTION
102: AND BY2.CALENDAR_CODE = BY1.CALENDAR_CODE

Line 99: BOM_CAL_YEAR_START_DATES BY2

95: ,'DD-MON-RRRR')
96: INTO YEARBEGINDATE,YEARENDDATE
97: FROM
98: BOM_CAL_YEAR_START_DATES BY1,
99: BOM_CAL_YEAR_START_DATES BY2
100: WHERE BY1.CALENDAR_CODE = S_CALENDARCODE
101: AND BY1.EXCEPTION_SET_ID = S_CALENDAREXCEPTION
102: AND BY2.CALENDAR_CODE = BY1.CALENDAR_CODE
103: AND BY2.EXCEPTION_SET_ID = BY1.EXCEPTION_SET_ID