eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_EXCHANGE_BUCKETING dependencies on MSC_PERIOD_START_DATES

Line 800: from msc_period_start_dates

796:
797: cursor c1 is
798: select distinct to_number(to_char(PERIOD_START_DATE,'j')) PERIOD_START_DATE,
799: to_number(to_char(NEXT_DATE-1,'j')) period_end_date
800: from msc_period_start_dates
801: where CALENDAR_CODE = p_calendar_code
802: and SR_INSTANCE_ID = p_sr_instance_id
803: and EXCEPTION_SET_ID = -1
804: and ( ( PERIOD_START_DATE <= to_date(p_start_date,'j')

Line 1401: from MSC_PERIOD_START_DATES

1397: select to_number(to_char(PERIOD_START_DATE,'J') ),
1398: to_number(to_char(NEXT_DATE-1,'J') )
1399: into lv_m_start_date ,
1400: lv_m_end_date
1401: from MSC_PERIOD_START_DATES
1402: where SR_INSTANCE_ID = p_instance_id
1403: and CALENDAR_CODE = p_calendar_code
1404: and EXCEPTION_SET_ID = -1
1405: and l_curr_date between to_number(to_char(PERIOD_START_DATE,'J'))