APPS.AZW_PROC dependencies on HR_OPERATING_UNITS

Line 625: FROM hr_operating_units

621:
622: ELSIF (ctx_type = 'OU') THEN
623: BEGIN
624: SELECT name INTO v_ctxt_name
625: FROM hr_operating_units
626: WHERE organization_id = ctx_id
627: AND date_from < SYSDATE
628: AND (date_to IS NULL
629: OR date_to > SYSDATE);

Line 636: fnd_message.set_token('AZW_ERROR_STMT','select name from hr_operating_units');

632: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
633: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
634: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
635: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
636: fnd_message.set_token('AZW_ERROR_STMT','select name from hr_operating_units');
637: APP_EXCEPTION.RAISE_EXCEPTION;
638: END;
639:
640: ELSIF (ctx_type = 'SOB') THEN

Line 876: FROM hr_operating_units

872: ORDER BY organization_id;
873:
874: CURSOR ou_cursor IS
875: SELECT organization_id, name
876: FROM hr_operating_units
877: WHERE date_from < SYSDATE
878: AND (date_to IS NULL
879: OR date_to > SYSDATE)
880: ORDER BY organization_id;

Line 1351: hr_operating_units hou

1347:
1348: CURSOR invalid_ou_processes_cursor IS
1349: SELECT ap.item_type, ap.process_name, ap.context_id
1350: FROM az_processes ap,
1351: hr_operating_units hou
1352: WHERE ap.context_type = 'OU'
1353: AND ap.process_type = g_current_mode
1354: AND ap.context_id > -1
1355: AND ap.context_id = hou.organization_id

Line 1380: from hr_operating_units);

1376: DELETE from az_processes
1377: WHERE context_type = 'OU'
1378: AND context_id not in
1379: ( select distinct organization_id
1380: from hr_operating_units);
1381:
1382: disable_invalid_opm_processes('OPMCOM');
1383: -- disable_invalid_opm_processes('OPMORG');
1384: