DBA Data[Home] [Help]

APPS.ARP_CMERGE_MASTER dependencies on HR_OPERATING_UNITS

Line 53: FROM hr_operating_units hr

49: l_temp_variable VARCHAR2(2000):=NULL;
50:
51: CURSOR get_operating_unit_csr IS
52: SELECT hr.name
53: FROM hr_operating_units hr
54: WHERE mo_global.check_access(hr.organization_id) = 'Y'
55: ORDER BY hr.name;
56:
57: BEGIN

Line 61: FROM hr_operating_units hr

57: BEGIN
58:
59: BEGIN
60: SELECT COUNT(*) INTO l_count
61: FROM hr_operating_units hr
62: WHERE mo_global.check_access(hr.organization_id) = 'Y';
63: EXCEPTION
64: WHEN OTHERS THEN
65: RETURN NULL;