DBA Data[Home] [Help]

APPS.MSC_EXCHANGE_BUCKETING dependencies on MSC_PLAN_ORGANIZATIONS

Line 715: | Get calendar code from the table msc_plan_organizations|

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:

Line 722: from msc_plan_organizations

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: /*------------------------------------------------------+