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 525: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS

521: l_additional_where VARCHAR2(2000);
522:
523: L VARCHAR2(240);
524:
525: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
526: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
527:
528: CURSOR c_strategy_level IS
529: SELECT PREFERENCE_VALUE

Line 1054: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS

1050: l_additional_where2 VARCHAR2(2000);
1051:
1052: L VARCHAR2(240);
1053:
1054: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
1055: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
1056:
1057: CURSOR c_strategy_level IS
1058: SELECT PREFERENCE_VALUE

Line 1698: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS

1694:
1695: L VARCHAR2(240);
1696:
1697:
1698: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
1699: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
1700:
1701: CURSOR c_strategy_level IS
1702: SELECT PREFERENCE_VALUE