APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_LOC_ASSIGNMENTS

Line 11686: FROM hz_loc_assignments la

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: );
11689: SELECT 'Y'
11690: INTO l_is_remit_to_location