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 8241: FROM dual;

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

Line 11674: FROM DUAL

11670:
11671: BEGIN
11672: SELECT 'Y'
11673: INTO l_loc_assignment_exist
11674: FROM DUAL
11675: WHERE EXISTS (SELECT 1
11676: FROM hz_loc_assignments la
11677: WHERE la.location_id = l_location_id
11678: );

Line 11681: FROM DUAL

11677: WHERE la.location_id = l_location_id
11678: );
11679: SELECT 'Y'
11680: INTO l_is_remit_to_location
11681: FROM DUAL
11682: WHERE EXISTS (SELECT 1
11683: FROM hz_party_sites ps
11684: WHERE ps.location_id = l_location_id
11685: AND ps.party_id = -1