DBA Data[Home] [Help]

APPS.IEX_UWQ_DELIN_ENUMS_PVT dependencies on HR_OPERATING_UNITS

Line 10: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS

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');

Line 635: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS

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

Line 1198: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS

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

Line 1877: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS

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