DBA Data[Home] [Help]

APPS.ARP_CMERGE_MASTER dependencies on MO_GLOBAL

Line 54: WHERE mo_global.check_access(hr.organization_id) = 'Y'

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
58:

Line 62: WHERE mo_global.check_access(hr.organization_id) = 'Y';

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;
66: END;

Line 1187: AND mo_global.check_access(m.org_id) <> 'Y'

1183: AND mh1.process_flag = l_new_process_flag
1184: AND NOT EXISTS (
1185: SELECT 'Y' FROM ra_customer_merges m
1186: WHERE m.customer_merge_header_id = mh1.customer_merge_header_id
1187: AND mo_global.check_access(m.org_id) <> 'Y'
1188: AND ROWNUM =1
1189: )
1190:
1191: AND ( EXISTS (