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 1176: and mo_global.check_access(m.org_id) <> 'Y'

1172: --Start of SSUptake
1173: AND NOT EXISTS (
1174: select 'Y' from ra_customer_merges m
1175: where m.customer_merge_header_id = mh.customer_merge_header_id
1176: and mo_global.check_access(m.org_id) <> 'Y'
1177: and rownum =1
1178: )
1179: --End of SSUptake
1180: AND ( EXISTS (