711: into jul_first_date
712: from dual;
713:
714: /*-------------------------------------------------------+
715: | Get calendar code from the table msc_plan_organizations|
716: | At present the code is defined at the plan level, so |
717: | get any row. |
718: +--------------------------------------------------------*/
719:
718: +--------------------------------------------------------*/
719:
720: select nvl(calendar_code, 1)
721: into p_cal_code
722: from msc_plan_organizations
723: where plan_id = p_plan_id
724: and rownum = 1;
725:
726: /*------------------------------------------------------+