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.

[Home] [Help]

APPS.MSC_X_HZ_UPDATE dependencies on MSC_PERIOD_START_DATES

Line 454: FROM msc_calendar_dates cal, msc_period_start_dates psd

450: elsif v_bucket_type(arg_pos) = MONTH_BUCKET then
451:
452: SELECT cal.next_date
453: INTO v_date
454: FROM msc_calendar_dates cal, msc_period_start_dates psd
455: WHERE psd.calendar_code = 'CP-Mon-70' AND
456: psd.exception_set_id = -1 AND
457: psd.sr_instance_id = 0 AND
458: psd.next_date > TRUNC(TO_DATE(v_start, 'DD/MM/YYYY HH24:MI:SS')) AND