APPS.MSC_GET_NAME dependencies on MSC_SCHEDULING_RULES

Line 2609: from msc_scheduling_rules msr

2605:
2606: FUNCTION DMD_PRIORITY_RULE (p_rule_id number) return varchar2 is
2607: cursor c_rule is
2608: select msr.meaning
2609: from msc_scheduling_rules msr
2610: where msr.rule_id = p_RULE_ID
2611: and nvl(msr.enabled_flag, 'Y') = 'Y';
2612:
2613: l_temp varchar2(240);

Line 5620: from msc_scheduling_rules

5616: FUNCTION get_default_dem_pri_rule_id return number
5617: is
5618: cursor dem_pri is
5619: select rule_id
5620: from msc_scheduling_rules
5621: where default_flag = 'Y'
5622: and enabled_flag = 'Y';
5623:
5624: l_rule_id number;

Line 5639: from msc_scheduling_rules

5635: return varchar2 is
5636:
5637: cursor dem_pri is
5638: select meaning
5639: from msc_scheduling_rules
5640: where default_flag = 'Y'
5641: and enabled_flag = 'Y';
5642:
5643: l_dem_rule varchar2(255);