6: PG_DEBUG NUMBER(2);
7:
8: PROCEDURE SET_MO_GLOBAL IS
9: L VARCHAR2(240);
10: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
11: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
12: BEGIN
13:
14: MO_GLOBAL.INIT('IEX');
631: l_additional_where VARCHAR2(2000);
632:
633: L VARCHAR2(240);
634:
635: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
636: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
637:
638: CURSOR c_strategy_level IS
639: SELECT PREFERENCE_VALUE
1194: l_additional_where2 VARCHAR2(2000);
1195:
1196: L VARCHAR2(240);
1197:
1198: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
1199: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
1200:
1201: CURSOR c_strategy_level IS
1202: SELECT PREFERENCE_VALUE
1873:
1874: L VARCHAR2(240);
1875:
1876:
1877: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
1878: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
1879:
1880: CURSOR c_strategy_level IS
1881: SELECT PREFERENCE_VALUE