APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on DUAL

Line 6371: FROM dual;

6367: 'I', 'N',
6368: '', DECODE(l_status, 'I', 'N')),
6369: 'Y')
6370: INTO l_dummy
6371: FROM dual;
6372:
6373: IF l_dummy <> 'Y' THEN
6374: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
6375: fnd_message.set_token('ENTITY', 'Site');

Line 8244: FROM dual;

8240: 'I', 'N',
8241: '', DECODE(l_status, 'I', 'N')),
8242: 'Y')
8243: INTO l_dummy
8244: FROM dual;
8245:
8246: IF l_dummy <> 'Y' THEN
8247: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
8248: fnd_message.set_token('ENTITY', 'language');

Line 11684: FROM DUAL

11680:
11681: BEGIN
11682: SELECT 'Y'
11683: INTO l_loc_assignment_exist
11684: FROM DUAL
11685: WHERE EXISTS (SELECT 1
11686: FROM hz_loc_assignments la
11687: WHERE la.location_id = l_location_id
11688: );

Line 11691: FROM DUAL

11687: WHERE la.location_id = l_location_id
11688: );
11689: SELECT 'Y'
11690: INTO l_is_remit_to_location
11691: FROM DUAL
11692: WHERE EXISTS (SELECT 1
11693: FROM hz_party_sites ps
11694: WHERE ps.location_id = l_location_id
11695: AND ps.party_id = -1